Best way to customize postgresql.conf?
reece
PROOP

a year ago

What's the best/recommended way to modify the Postgres config on Railway (ideally, without creating a custom image)?

Solved

19 Replies

a year ago

In what ways would you be looking to customize it?


reece
PROOP

a year ago

my app needs pg_stat_statements in shared_preload_libraries


a year ago

You can't directly edit the postgresql.conf file (Maybe through SSH but definitely not recommended)


a year ago

Can that be sent as a psql command or set through env vars?


a year ago

Was looking into all that env vars can do yeah, I've had some people customize them through those


reece
PROOP

a year ago

wouldn't be persisted over a restart, which is required after modifyng the config


a year ago

True, so unfortunately a custom image is the best option here


reece
PROOP

a year ago

ah, that's annoying but oh well


a year ago

looking through this but yeah https://hub.docker.com/_/postgres

custom image is the best bet


reece
PROOP

a year ago

I wonder if there could be some middle ground where it has a startup script that writes a config to the disk on startup, from an environment variable


reece
PROOP

a year ago

just thinking out loud


a year ago

Yeah that sounds like it would be helpful here but no clue if Railway supports doing that


a year ago


a year ago

brody to the rescue


reece
PROOP

a year ago

oh wow i could not find that


reece
PROOP

a year ago

thanks brody


reece
PROOP

a year ago

!s


a year ago

!s


reece
PROOP

a year ago

:/


Status changed to Solved medim • about 1 year ago


Welcome!

Sign in to your Railway account to join the conversation.

Loading...