By default, when you include a 2nd standby that participates from the replication quorum then pg_auto_failover increments its number-sync-standbys from zero to one in order that as a substitute, Whenever your Major node is the only real 1 left, then all transactions which have been creating facts are put on-hold https://erick431nxi2.wikihearsay.com/user