What is the easiest way to migrate posgresql database to another server?



  • I have set up my PostgreSQL database on the server up and running, but soon the server is going to be destroyed, so I need to migrate the database to another server? What is the most comprehensive approach to that, with a note that the database has data in its tables?



  • If the architecture on both systems is the same, (say, 64-bit Linux on the same hardware architecture), you can simply copy the data directory. There are a few things to observe:

    • you have to use the same PostgreSQL versions on both systems

    • unless the C library version is the same or you are using the C collation, you had better reindex all indexes on string expressions, because the collation might have changed




Suggested Topics

  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2