[GENERAL] mirroring a server and/or hot standby

2015-06-24 Thread 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?

Re: [GENERAL] mirroring a server and/or hot standby

2015-06-24 Thread John Bleichert
I use pg_dumpall for regular backups and can definitely use one of those backups to kickstart the new server. Would I then configure that new server instance as a standby server as per doc section 18.6? Or should I just setup the standby server first? Having re-read 18.6 I think this is what I

Re: [GENERAL] mirroring a server and/or hot standby

2015-06-24 Thread Holger.Friedrich-Fa-Trivadis
/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

Re: [GENERAL] mirroring a server and/or hot standby

2015-06-24 Thread Holger.Friedrich-Fa-Trivadis
John Bleichert wrote on Wednesday, June 24, 2015 4:21 PM: Ø Would I then configure that new server instance as a standby server as per doc section 18.6? Ø Or should I just setup the standby server first? Having re-read 18.6 I think this is what I want. I may be wrong but I’m not sure a