Is it possible to do Postgres config settings change
jimin-genie
PROOP

a year ago

I ran SHOW config_file; and I see the config file located at /var/lib/postgresql/data/pgdata/postgresql.conf.

I need to modify the variables in that file to
shared_preload_libraries = 'pg_stat_statements'
so that I can take a look at the statistical data collected by that extension for DB performance.

Is this possible with Railway's Postgres DB service?

4 Replies

jimin-genie
PROOP

a year ago

3747f720-8c9c-4d81-9b13-1e420ceabd6c


a year ago

please see the Postgres documentation -


jimin-genie
PROOP

a year ago

Oh ok, so all config values can be done via SQL and you just want us to simply refresh the configs in SQL?


a year ago

yeah that's how it's done for Postgres, nothing platform specific at all


Loading...