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