synchronous_standby_names
No restart — takes effect on reloadtuned by pgconfiguratorstandby name list / quorum expression
Names the standbys that must confirm a commit for synchronous replication.
What pgconfigurator would set
32 GB · 8 vCPU · NVMe · OLTP
Computing…
Tune for your exact server → /tunecomputed in your browser · nothing uploaded
What it does
This lists which standbys participate in synchronous replication — when set, a COMMIT (with synchronous_commit at remote_write/on/remote_apply) waits until the named standbys acknowledge the WAL. It supports quorum expressions like ANY 1 (s1, s2). Empty means all replication is asynchronous.
How to tune it
Set it only when you need zero-data-loss failover and accept that commits now wait on the network and the standby. Use a quorum (e.g. ANY 1 (...)) so one slow/down standby doesn't stall all writes. Pair with a sensible synchronous_commit level.