Share via

How to migrate from Azure Database postgres (Single server) tier to Flexible Server with minimal downtime and no data loss?

Maulik Modi 21 Reputation points
2021-12-15T08:18:11.27+00:00

Hello team,

We would like to transfer our User acceptance testing environment from Azure database postgres(single server) to Azure database postgres(flexible server) plan for Cost optimisation reasons. Our data size is 10 GB.

We have 5 databases and activated - pgcrypto, Dblink extensions.

Appreciate if there is any how to guide/steps to migrate with minimum downtime and no data loss?

Thanks,
Maulik.

Azure Database Migration Service
Azure Database for PostgreSQL

Answer accepted by question author

Anurag Sharma 17,636 Reputation points
2021-12-15T09:45:47.173+00:00

Hi @Maulik Modi , welcome to Microsoft Q&A forum.

You can refer to below blog for the same:

Migrate your database from PostgreSQL Single Server to PostgreSQL Flexible Server using Azure DMS

As both Single Server and Flexible Server support those extensions mentioned by you, this should work fine.

Please let us know if this helps or if you have any other queries and we will be delighted to discuss further. If answer helps you can mark it as 'Accept Answer'.

Was this answer helpful?

1 person found this answer helpful.
0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.