By default, if you add a 2nd standby that participates inside the replication quorum then pg_auto_failover increments its number-sync-standbys from zero to 1 so that as a substitute, when your Principal node is the only real a person remaining, then all transactions which might be writing facts are put on-hold https://slot-pg-auto65421.estate-blog.com/29292890/rumored-buzz-on-slot-pg-auto