By default, once you incorporate a next standby that participates inside the replication quorum then pg_auto_failover increments its selection-sync-standbys from zero to at least one so that instead, when your Main node is the only one remaining, then all transactions that happen to be crafting facts are placed on-keep until eventually a standby no