Postgres is excellent at ready, and really affected individual: When the standby node turns into unavailable, then the consumer connection stays on-keep for an infinite time period (or not less than until finally a restart). We produced the open supply pg_auto_failover to carry out fault tolerance for Postgres architectures in https://slotpgauto99753.thechapblog.com/29249313/getting-my-slot-pg-auto-to-work