PGAUTO - AN OVERVIEW

By default, any time you add a next standby that participates within the replication quorum then pg_auto_failover increments its number-sync-standbys from zero to 1 making sure that alternatively, Once your Main node is the sole 1 remaining, then all transactions that are creating knowledge are placed on-hold right until a standby node is available