Hello I'm implementing HA/failover for my PG nodes. I'm using PG9.0 and async replication and linux.
Typical problem - if node 1 fails I want the mirror to become active and take over for the master. The solution should be able to initiate the failover of the standby and start re-directing traffic it. I've spent a lot of time looking at PgPool so I'm well aware that it's perfectly capable of this. However, it feels a little bit like overkill since i don't want it's pooler and I'm not load balancing. The other option would be RHCS, which I know will work, but to implement it with pg replication is a little hacky. So, I'm considering HAProxy, does anyone have experience with that for managing HA, good or bad? Thanks. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
