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 No comments
{count} vote

Accepted answer
  1. GeethaThatipatri-MSFT 29,517 Reputation points Microsoft Employee
    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

    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful

Your answer

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