Pgpool-II
connection pooling,
replication management, load balancing,
and request queuing
That seems like overkill, and that much
abstraction forces a black box on us.
Bucardo
multi-master, and asynchronous
replication
We need synchronous replication, and
we don’t need multi-master.
Repmgr
replication management
and automatic failover
Does one thing, does it well. Plus, it’s
written by 2nd Quadrant.
Tools, tools