Search Postgresql Archives

Re: Data Replication

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux