3 months ago
I build a query and it accident make overload the Memory database. Now everything working, api still connected and return data but when I look at Postgres/Database -> Connection it alway restart and return:
psql: error: connection to server at "localhost" (::1), port 5432 failed: FATAL: parameter "shared_preload_libraries" cannot be changed without restarting the server
I tried restarted deployment but still get same error, can anyone help?
1 Replies
3 months ago
According to PostgreSQL docs:
shared_preload_libraries must be set at server start
It cannot be changed via reload
If Postgres detects a mismatch, it'll refuse the connection and restart
To prevent this next time, avoid queries that will kill the memory. Always run LIMIT on large queries, avoid unbounded JOINs, and be careful with running SELECT * on large tables.
Keep an eye on your metrics too, watch out for RAM spikes and how many times your database is restarting - if you're frequently hitting your memory limits then consider different options such as how much power the deployment has or reducing the connection pool size.
But you came here for a fix, and this is probably something you won't want to hear, but it'll help you in future:
Reset your database through your Postgres deployment - this'll force a fresh data directory.
OR if you have a backup, restore the latest healthy snapshot that you know works and then re-deploy.