> Version 8.3 has pg_standby. Does anyone know how well that works for
> failover?
pg_standby is part of the Point in time recovery suite, which can be
used to create a cold (recovery on comand) or warm standby (continuous
recovery) server ready to take over with a few commands. It's quite
different from slony, in that there's not hot read-only standby, so
there's no load balancing, however, it usually produces less load on
the master db, so that's a plus.
PITR is quite well tested and used in a lot of production
environments. It has very different design objectives than slony or
pgpool or pgbouncer, which all allow you to have multiple live servers
at once.
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
No comments:
Post a Comment