Is the Azure Database for PostgreSQL single server dropped after its migrated to flexible server?

Ravi Prabhat Dubey 20

I want to migrate my Azure Database for PostgreSQL single server to flexible server. I was wondering what will happen to the single server database after it is migrated to flexible server?

Basically the question is two-fold where I would like to understand

if something goes wrong after the migration due to unforeseen reasons, can we fix at source and trigger the migration again?
and do we need to housekeep the old database ourselves?

Ravi Prabhat Dubey 20 Reputation points

2024-08-15T07:51:50.2133333+00:00

Hi ShaktiSingh-MSFT,

Thanks for the response.

Do you mean the source database remains as it is even after it is migrated to flexible server and I end up with two different instances of the same database - one on the single server (source) and another on the flexible server (target)?

If yes, then does the source database remains the primary database since it is still connected with its upstream systems?
ShaktiSingh-MSFT 15,301 Reputation points

2024-08-23T06:01:59.8733333+00:00

Hi Ravi Prabhat Dubey •,

Currently, the Single Server to Flexible Server migration tool only supports offline migrations. Offline migration requires downtime to your applications during the migration process. For more information, see Migration tool - Azure Database for PostgreSQL Single Server to Flexible Server.

Downtime depends on several factors, including the number of databases, size of your databases, number of tables inside each database, number of indexes, and the distribution of data across tables. It also depends on the SKU of the source and target server and the IOPS available on the source and target server.

Given the many factors involved in a migration, the best approach to estimate downtime to your application is to try the migration on a PITR server restored from the primary server to plan for your production migration.

Offline migrations are less complex, with few chances of failure, and are the recommended way to perform migrations from a single server to a flexible server for workloads with service windows.

You can contact your account teams if downtime requirements aren't met by the Offline migrations provided by a single server to a Flexible migration tool.

The billing should be comparable if you choose a similar configuration to your Azure Database for PostgreSQL - Single Server. However, if you select the same zone or zone redundant with high availability for the target flexible server, your bill will be higher than it was on your single server. Same zone or zone redundant high availability requires an additional hot standby server to be spun up and store redundant backup data, hence the added cost for the second server. This architecture enables reduced downtime during unplanned outages and planned maintenance. Generally speaking, Flexible Server provides better price performance, however, this is dependent on your workload.

Hope this helps.

Thanks
Ravi Prabhat Dubey 20 Reputation points

2024-08-26T02:26:43.88+00:00

Hi ShaktiSingh-MSFT,

Thanks again for your response. However, this still doesn't answer my questions here.

I'll try to rephrase the question as below-

"I want to move my Azure Database for PostgreSQL from a single server to a flexible server. What will happen to my old database after the move? Can I undo the move if something goes wrong, and will Microsoft automatically delete the old database?"
ShaktiSingh-MSFT 15,301 Reputation points

2024-08-26T05:58:12.55+00:00

Hi Ravi Prabhat Dubey •,

Thanks!

You can perform any number of test migrations, test the success of your migration, and perform the final migration once you're ready. Test migrations don't affect the single server source, which remains operational until you perform the migration. If there are any errors during the test migration, you can postpone the final migration and keep your source server running. You can then reattempt the final migration after you resolve the errors. After you've performed a final migration to a flexible server and opened it up for the production workload, you'll lose the ability to go back to single server without incurring a data loss.

Accepted answer

Nyanaraam Kanaisan 80 Reputation points Microsoft Employee

2024-08-26T05:52:43.7433333+00:00

Hi @Ravi Prabhat Dubey If you opted for Automigration, your old Azure Database for PostgreSQL Single Server will be deleted after 7 days.

Other migrations methods such as Dump&Restore and Flexible Migration service will not delete your old Azure Database for PostgreSQL Single Server. You will need to delete it by yourself once your application is stable accessing the new Azure Database for PostgreSQL Flexible Server.

If something goes wrong during the migration, you can still fix things on source and triggers the migration again.

Thank you.
Please sign in to rate this answer.

1 person found this answer helpful.

0 comments No comments
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

1 additional answer

ShaktiSingh-MSFT 15,301 Reputation points

2024-08-14T08:55:37.7133333+00:00

Hi Ravi Prabhat Dubey •,

Welcome to Microsoft Q&A forum.

As I understand, you want to know if the existing Azure Database for PostgreSQL Single Server will be dropped after it's migrated to Flexible Server.

Q. What happens to my existing Azure Database for PostgreSQL - Single Server instances?

A. Your existing Azure Database for PostgreSQL - Single Server workloads will continue to be supported until March 2025.

Refer to more such FAQs on migration here:

https://learn.microsoft.com/en-us/azure/postgresql/single-server/whats-happening-to-postgresql-single-server

Let us know if this helps or you have a different ask.

Thanks
Please sign in to rate this answer.

0 comments No comments
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

Is the Azure Database for PostgreSQL single server dropped after its migrated to flexible server?

1 additional answer

Your answer