Azure database for postgre SQL flexible server

Question

I got suggestion to migrate from azure database for single server to flexible server.what happened to single server?can anyone please help me in understanding the difference between azure database for postgre SQL single server and flexible server if possible provide any documentation on this. Thanks in advance.

Answer 1

Hi @Vogue Medico,

Thanks for the question and using MS Q&A platform.

Here is the clear explanation.

what happened to single server?

Azure Database for PostgreSQL - Single Server is being retired by March 28, 2025. This service, which became available in 2018, is being replaced by a new option called Azure Database for PostgreSQL - Flexible Server. This new version offers better performance, scalability, and control.

Starting November 30, 2023, you won't be able to create new Single Server instances through the Azure portal, but you can still use the Azure CLI to create them until March 2025 if necessary.

If you currently have a Single Server for your production needs, you can migrate to the Flexible Server for better features and management options.

Difference between Azure Database for PostgreSQL single server and Flexible server:

Single server:

It is a managed database service that requires very little setup from users. It takes care of most tasks like updates, backups, security, and ensures high availability, achieving 99.99% uptime in a single location. It supports versions of PostgreSQL from 9.5 to 11.

There are three pricing tiers: Basic, General Purpose, and Memory Optimized, each with different resource levels to fit your needs. You can start with a small, affordable database and scale up as your application grows. The service automatically adjusts resources based on demand, so you only pay for what you use.

This service is ideal for cloud-native applications that can handle automatic updates without needing detailed control over the update schedule or specific PostgreSQL settings.

Flexible server:

It is a managed database service that gives you more control and customization options. It allows you to choose high availability either within a single location or across multiple locations.

This service helps you save costs because you can start and stop the server as needed, and it offers a burstable compute option for workloads that don't require constant full power.

It currently supports PostgreSQL versions from 11 to 17 (in preview) and will include newer versions as they come out. The Flexible Server is available in many Azure regions today.

Documentation: https://learn.microsoft.com/en-us/azure/postgresql/flexible-server/service-overview

Hope this helps. Do let us know if you any further queries. If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.