Alan, On 2011-06-15 19:54, Alan Gutierrez wrote: > I'd like to use HAProxy to implement a simple proxy that can perform > failover for a pair of PostgreSQL configured as master/slave with > PostgreSQL 9.0 streaming replication to replicate the master to the > slave. Only the master is active for client connections, unless the > master fails, then the clients should connect to the slave while an > administrator recovers the master.
You might also want to have a look at pgpool-II [1] which is a proxy specifically designed for failover, replication and loadbalancing of Postgres servers. Recent versions can take advantage of the built-in asynchronous replication feature of Postgres 9. Using this, you can * configure failover and recovery * potentially utilize the second machine for read-only queries. --Holger [1] http://pgpool.projects.postgresql.org