How to persist changes to Postgres .conf?
alec-gillis
PROOP

a year ago

I am interested in modifying the max_connections on my deployed PostgreSQL instance using the postgres-ssl:15 Railway template image.

With a Postgres superuser I have run "ALTERSYSTEMSET max_connections = 300;" then redeploy the Postgres container.

The change to max_connections is not applied when I run "SHOW max_connections;"

I assumed the .conf changes to be written to the long-lived volume & apply to the next container deployment. Is there a way to modify the .conf settings without modifying the dockerfile / dockerfile entrypoint command?

Solved

3 Replies

brody
EMPLOYEE

a year ago

Hello,

Have you done a SELECT pg_reload_conf(); before redeploying / restarting?

I have tested this method and it works -

ALTER SYSTEM SET max_connections = '200';
SELECT pg_reload_conf();

And then restarted via the 3-dot menu.

Bes,
Brody

heart1

Status changed to Awaiting User Response Railway • 11 months ago

alec-gillis
PROOP

a year ago

That worked, thank you! I appreciate your response Brody.

Status changed to Awaiting Railway Response Railway • 11 months ago

brody
EMPLOYEE

a year ago

Happy to help!

Status changed to Awaiting User Response Railway • 11 months ago

Status changed to Solved brody • 11 months ago

Loading...