What's the best/recommended way to modify the Postgres config on Railway (ideally, without creating a custom image)?
#Best way to customize postgresql.conf?
dusk moat
analog basin
In what ways would you be looking to customize it?
dusk moat
my app needs pg_stat_statements in shared_preload_libraries
fervent lava
You can't directly edit the postgresql.conf file (Maybe through SSH but definitely not recommended)
Can that be sent as a psql command or set through env vars?
analog basin
Was looking into all that env vars can do yeah, I've had some people customize them through those
dusk moat
wouldn't be persisted over a restart, which is required after modifyng the config
fervent lava
True, so unfortunately a custom image is the best option here
dusk moat
ah, that's annoying but oh well
analog basin
looking through this but yeah https://hub.docker.com/_/postgres
custom image is the best bet
dusk moat
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
just thinking out loud
analog basin
Yeah that sounds like it would be helpful here but no clue if Railway supports doing that
loud salmon
fervent lava
brody to the rescue
fervent lava
!s
dusk moat
:/