mirroring a server and/or hot standby

From: John Bleichert <jbleichert(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: mirroring a server and/or hot standby
Date: 2015-06-24 13:54:57
Message-ID: CAK+3iQWutuE0uzCZ=+NzAri_SZ1GX6_sN_DTV3+tWeMg-EG7Gw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Geoff Winkless 2015-06-24 14:03:13 Re: Counting the occurences of a substring within a very large text
Previous Message Marc Mamin 2015-06-24 13:51:31 Re: Counting the occurences of a substring within a very large text