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@xxxxxxxxxxxxxx [mailto:pgsql-general-owner@xxxxxxxxxxxxxx] On Behalf Of John Bleichert 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 |
