By default, whenever you add a 2nd standby that participates inside the replication quorum then pg_auto_failover increments its number-sync-standbys from zero to at least one in order that instead, Once your Major node is the only real one particular still left, then all transactions that are producing info are placed on-hold right until a standby