Hi @ADS Thank you for posting your question. Azure Database for PostgreSQL is available in three deployment modes: Single Server, Flexible Server (Preview) and
Hyperscale. As you mentioned above server less is available for Azure SQL and Cosmos DB not in PostgreSQL. The only option will be to use flexible server to scale across tiers. The flexible server service allows you to stop and start server on-demand to lower your TCO. The compute tier billing is stopped immediately when the server is stopped.
In the meantime, I will check with our product group if there is another option.
Regards,
Oury