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.