PGAUTO SECRETS

By default, once you insert a second standby that participates inside the replication quorum then pg_auto_failover increments its selection-sync-standbys from zero to at least one to ensure that alternatively, Once your primary node is the sole just one still left, then all transactions that happen to be writing information are put on-maintain unti