By default, after you add a 2nd standby that participates while in the replication quorum then pg_auto_failover increments its number-sync-standbys from zero to 1 so that as an alternative, when your Main node is the only real one still left, then all transactions that are composing facts are placed on-maintain https://erinz975ubi1.plpwiki.com/user