CONSIDERATIONS TO KNOW ABOUT SLOT PG AUTO

By default, if you increase a second standby that participates from the replication quorum then pg_auto_failover increments its number-sync-standbys from zero to 1 to ensure that alternatively, Once your primary node is the only a single left, then all transactions which might be producing details are placed on-hold till a standby node is available