Moving a Postgresql Database to new Server

How to move a Postgresql database to a new server

I had to move a very large postgresql database from one server to another recently. The old server was version 8.4 and new was 9.2.1

Here is the pg_dump command I used from Linux command line:
here is the pg_restore command done from regular Linux command line:
pg_restore -C -d postgres db.dump

Leave a Reply

Your email address will not be published. Required fields are marked *