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