On Thu, Sep 11, 2008 at 7:42 AM, Rex Mabry <[EMAIL PROTECTED]> 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. -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
