Pgpool-II with PostgreSQL
What is Pgpool-II?
Pgpool-II is a middleware that can run on Linux and Solaris between applications and PostgreSQL databases.
Its main features include the following:
Load balancing
Replication
Connection pooling
Automatic failover
Online recove...
techblog.geekyants.com10 min read
Joseph Craig
Always learning
New to psql and had a question about this deployment, well a few. 1st how would you do a planned failover from the primary node to the secondary node in a planned method like patching or something like that?
2nd During failover testing it seemed that both nodes had to be up before restarting pgpool2 to get things back healthy, is that normal or do I have something off?
3rd How would you recommend expanding the architecture to eliminate the pgpool server as a single point of failure for HA?