Re: Data Replication - Mailing list pgsql-general

From Andrew Sullivan
Subject Re: Data Replication
Date
Msg-id 20081211161240.GF26521@shinkuro.com
Whole thread Raw
In response to Re: Data Replication  ("Scott Marlowe" <scott.marlowe@gmail.com>)
List pgsql-general
On Wed, Dec 10, 2008 at 08:41:30PM -0700, Scott Marlowe wrote:

> one of the real time replication.  Failover in slony is pretty easy to
> do and happens in seconds.  But you do have to resubscribe the master
> as a slave and copy everything over again after a failover to make the
> old master the new master again.

Note, however, that you can do controlled switchover in Slony that
requires no re-sync.  If your hardware-health monitors are any good
(and they ought to be), you can use them to tell you that something is
wrong, and switch before things blow up.  It's not perfect, but it has
been useful to me.


--
Andrew Sullivan
ajs@crankycanuck.ca

pgsql-general by date:

Previous
From: "Jonathon Suggs"
Date:
Subject: Query Question (one group by vs two separate)
Next
From: Tom Lane
Date:
Subject: Re: Startup process thrashing