Postgres is superb at waiting, and very client: When the standby node will become unavailable, then the client link stays on-hold for an infinite stretch of time (or at least until eventually a restart). We produced the open source pg_auto_failover to put into action fault tolerance for Postgres architectures in https://wardf219lyj2.iamthewiki.com/user