By default, after you increase a second standby that participates inside the replication quorum then pg_auto_failover increments its amount-sync-standbys from zero to one making sure that as a substitute, Once your Principal node is the only just one still left, then all transactions which might be writing knowledge are put on-maintain until finall