PostgreSQL Single Server migration in flexible server.

Question

Team,
Currently, we are using Azure PostgreSQL Single Server, but as its support has ended, we are required to migrate to Azure PostgreSQL Flexible Server. We have received a notification that the default migration is scheduled for March 16.

Since this is our production server, we want to ensure a smooth migration with zero downtime and minimal disruption to our current setup. I have some questions regarding the migration process and would appreciate your assistance.

Looking forward to your response.

Thank you.

Answer 1

Hi Tripesh Dhoriya,

As you're aware, Azure Database for PostgreSQL - Single Server is scheduled for retirement by March 28, 2025. In response, Microsoft has initiated an automigration process to transition existing Single Server instances to Flexible Server. You've received a notification that your production server's migration is scheduled for March 16.

To ensure a smooth migration with minimal downtime, it's crucial to understand the available migration options:

1. Offline Migration: Automigration(Offline Migration) this is a service-initiated migration conducted during a planned downtime window, separate from regular maintenance. While it simplifies the migration process, it involves some downtime.
2. Online Migration: Utilizing the Azure Database for PostgreSQL Migration Service, this approach allows for minimal downtime by setting up continuous data replication from the Single Server to the Flexible Server. This method is ideal for production environments where uptime is critical.

For more details on Online migration Refer this link: https://learn.microsoft.com/en-us/azure/postgresql/migrate/migration-service/tutorial-migration-service-single-to-flexible?tabs=portal%2Conline