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-ow...@postgresql.org [mailto:pgsql-general-ow...@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! Thanks in advance, John
