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@xxxxxxxxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general