By default, after you add a second standby that participates from the replication quorum then pg_auto_failover increments its selection-sync-standbys from zero to one to ensure instead, when your Major node is the one just one remaining, then all transactions that are creating info are placed on-keep until a standby node https://chiefu752mta7.wikiitemization.com/user