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?