We manage our infrastructure with puppet and vagrant. The DB nodes run Postgresql in synchronous replication mode and we have pgpool2 in front of the DB nodes as a load balancer and failover monitor. We have implemented and tested failover, failback and follow master commands that are executed from the pgpool on the DB nodes in case of node failure.
We are looking for pgpool / postgres expert that can fix/validate our configuration so we get rid of some instabilities that are left. Currently, we need the setup to be able to run on (at least) 3 nodes.
This is our DB related stack:
- puppet 3.3.1
- ubuntu 12.04
- postgres 9.3
- pgpool 3.3.1
We are available for а skype call/chat for further details.