steep agate
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?
covert laurelBOT
steep agate
3747f720-8c9c-4d81-9b13-1e420ceabd6c
finite silo
please see the Postgres documentation - https://www.postgresql.org/docs/current/sql-altersystem.html
steep agate
Oh ok, so all config values can be done via SQL and you just want us to simply refresh the configs in SQL?
finite silo
yeah that's how it's done for Postgres, nothing platform specific at all