On Thu, Sep 11, 2008 at 7:42 AM, Rex Mabry <rexmabry@yahoo.com> wrote:
> 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.