Postgres is excellent at ready, and very affected individual: When the standby node gets to be unavailable, then the client connection stays on-maintain for an infinite timeframe (or at the very least till a restart). We created the open supply pg_auto_failover to implement fault tolerance for Postgres architectures in manufacturing. https://connerjcsqv.blogscribble.com/29853373/5-easy-facts-about-slot-pg-auto-described