Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2014
    Posts
    1

    Unanswered: Migrating database to another server

    Hi,

    I need to migrate postgresql database from one server to another in the company I work in.

    This is the article I refer to :

    PostgreSQL: Documentation: 8.3: Backup and Restore

    However, I was wondering is there anything I have do in the original database server before migrating?

    There are replications happening all the time in the original database server, so is it safe to directly execute the commands given in the guide above?

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Disable replication before you move the database, then re-enable replication when the database move is complete.

    -PatP
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •