Is it possible to do Postgres config settings change
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?Solution:Jump to solution
please see the Postgres documentation - https://www.postgresql.org/docs/current/sql-altersystem.html
5 Replies
Project ID:
3747f720-8c9c-4d81-9b13-1e420ceabd6c3747f720-8c9c-4d81-9b13-1e420ceabd6c
Solution
please see the Postgres documentation - https://www.postgresql.org/docs/current/sql-altersystem.html
Oh ok, so all config values can be done via SQL and you just want us to simply refresh the configs in SQL?
yeah that's how it's done for Postgres, nothing platform specific at all