Proper way to change postgresql.conf?

hapostgres / pg_auto_failover

Postgres extension and service for automated failover and high-availability

Other

1.07k stars 113 forks source link

Proper way to change postgresql.conf? #896

Closed kevinelliott closed 2 years ago

kevinelliott commented 2 years ago

What is the correct procedure to update postgresql.conf?

I have tried to edit max_connections and then perform a failover, but the setting doesn't seem to stick. Is there a proper way to simply restart the nodes to take in the new setting?

s4ke commented 2 years ago

Since the postgresql.conf does not seem to be part of the failed over data, the simplest way is to just keep the config files in sync manually or via rollout script.

This is what we have been doing for a while now and we had several failovers/switchovers happen without issue.