fly-apps / postgres-flex

Postgres HA setup using repmgr
67 stars 32 forks source link

Replica crashes when decreasing `max_connections` #188

Open davissp14 opened 1 year ago

davissp14 commented 1 year ago

The fly pg config update tool will currently perform a rolling-restart in order to apply configuration changes that cannot be applied at runtime. As of right now, all restarts will start with the replicas and end with the primary.

This process does not work in some cases when adjusting configuration values down.

As an example, a replica will not boot if its max-connections value is lower than the value specified by the primary.