Repository navigation
Change postgresql.conf settings on primary and standby via pg_autoctl #80
Description
It would be useful if pg_autoctl had a command to change a setting like max_connections or shared_buffers when streaming replication is set up. We basically need to make sure that both servers have the setting in their postgresql.conf (or include) and then do a restart, preferably without triggering a failover.
Activity
[-]Allow pg_autoctl to change postgresql.conf settings on primary and standby[/-][+]Change postgresql.conf settings on primary and standby via pg_autoctl[/+]dimitri commentedon Oct 14, 2026
This is now available:
pg_autoctl restart postgres --maintenance(PR #1198).It restarts Postgres to pick up a
postgresql.conf/ALTER SYSTEM SETchange, wrapping the restart in maintenance mode so the monitor doesn't trigger a failover while the node is down — e.g.:This hasn't shipped in a release yet — it's merged to
mainand should land in the next pg_auto_failover release, probably in November. See the manual page forpg_autoctl restart postgresand the worked example indocs/operations.rstin the meantime.