On 7/15/2013 8:55 AM, Jorge Torralba wrote:
I have a master and a slave running streaming replication between the two servers. I would like to setup some kind of third machine to play the role of observer node to monitor the replication and do the automatic fail over. However, I can't find any documentation or suggestions on such an implementation. Is it possible to do with 9.2.4 or will I need to rely on some sort of F5 load balancer to handle the auto failover?
Depends on your OS. We do this all the time with our HAC setups and we don't need any kind of load balancer to pull it off.
JD -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin