By default, after you insert a second standby that participates while in the replication quorum then pg_auto_failover increments its number-sync-standbys from zero to 1 so that rather, Once your Main node is the one one left, then all transactions that happen to be creating facts are put on-keep right up until a standby node is available once again… Read More