a year ago
In my project 422b2419-6775-45be-a3bb-10fb9ade63db, I have deployed an instance of pghero (https://github.com/ankane/pghero) to monitor the performance of my database. Part of the stats I need to see require modification on the postgresql.conf:
shared_preload_libraries = 'pg_stat_statements'
pg_stat_statements.track = allSoon, I will also need to modify the connection limit:
max_connections = 200I don't see any docs yet that show how to do this. Is this possible?
3 Replies
a year ago
The Postgres databases are near standard Postgres docker images with some self signed certs, so any query that would modify these values would work on the Railway hosted Postgres database.
a year ago
Ah, you mean these options would be configurable via SQL? What would the commands be like?
a year ago
As the Postgres database that gets deployed by Railway are standard Postgres databases, the applicable commands that would set these values for Postgres would also work on the Railway hosted database, so I would recommend familiarizing yourself with the commands you need to accomplish your desired changes.
Status changed to Solved railway[bot] • 12 months ago