Hi all, running PostgreSQL 14, physical replication with slot, after changing (increasing) the max_connections on the primary, I had this message at a restart from the standby:
DETAIL: max_connections = 100 is a lower setting than on the primary server, where its value was 300.
and the standby does not start until I raise also its max_connections. Why is PostgreSQL requiring the max_connections to be aligned between the primary and the standby?
Thanks, Luca
No. iirc, It has to be the same on all nodes in the physical replication setup.
But if vis pgbouncer, you can maintain the same max_connection but alter active front-end backend connections.