Hello John,
Since you mentioned a different OS and want to copy the entire instance it would seem that pg_dumpall is the way to go.
You would then import the dump into the new instance using psql.
See:
http://www.postgresql.org/docs/9.4/static/app-pg-dumpall.html
http://www.postgresql.org/docs/9.4/static/app-psql.html
Best regards,
Holger Friedrich
From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-owner@postgresql.org] On Behalf Of John Bleichert
Sent: Wednesday, June 24, 2015 3:55 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] mirroring a server and/or hot standby
Hello All,
I am looking for documentation pointers on how to move the contents of an existing/working single-instance server to a new instance. As in: I have a Postgres server running in a VM and I want to move it to a different OS in a different VM guest.
Is there a way to gracefully do this? Is there a way to "sync" to a new server? Do I need to do this the hard way by manually copying all the data over to a new server with SQL?
It seems that setting up a hot standby server may be the way to go but chapter 25 in the user doc is scant on setup/install detail for this configuration. I am also interested in setting up an offsite hot standby server for failover.
Suggestions for tools and/or further reading welcome!