Share via

Postgres -flexible server migration

Jellybean 26 Reputation points
2022-06-29T00:56:49.357+00:00

we are migrating postgres server to another postgres, please tell me what i need to use DMS or PGDUMP which is the best way

Azure Database for PostgreSQL
0 comments

Answer accepted by question author

GeethaThatipatri-MSFT 29,597 Reputation points Microsoft Employee Moderator
2022-06-29T01:29:57.537+00:00

Hi, @Jellybean Welcome to the Microsoft Q&A forum, and thanks for reaching out.
As we understand you are migrating the Postgres server to a different Postgres server and want to know what is the best way to do it.
Always dump and restore are better options as it less complicated but again if downtime and other factors come into play then DMS might provide better alternatives.
Offline method using PostgreSQL pg_dump and pg_restore which incurs downtime for migrating the data. This document addresses this method of upgrade/migration.

Online method using Database Migration Service (DMS). This method provides a reduced downtime migration and keeps the target database in-sync with the source and you can choose when to cut-over. However, there are a few prerequisites and restrictions to be addressed for using DMS. For details, see the DMS documentation

Regards
Geetha

Was this answer helpful?

1 person found this answer helpful.

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.