Fix Postgres DB

Me being dumb ran the following on my Postgres...
ALTER SYSTEM SET shared_preload_libraries = 'timescaledb,pg_stat_statements';
ALTER SYSTEM SET shared_preload_libraries = 'timescaledb,pg_stat_statements';
which has entered the database into an endless cycle of errors
2023-06-18 00:54:39.469 UTC [1] FATAL: could not access file "timescaledb,pg_stat_statements": No such file or directory
2023-06-18 00:54:39.469 UTC [1] LOG: database system is shut down
2023-06-18 00:54:39.469 UTC [1] FATAL: could not access file "timescaledb,pg_stat_statements": No such file or directory
2023-06-18 00:54:39.469 UTC [1] LOG: database system is shut down
but I can't undo what I did because the DB wont start. How can I fix this?
12 Replies
Percy
Percy2y ago
Project ID: 6d146cc0-b14a-41e6-80f6-6d0a0baf99d7
Connor
ConnorOP2y ago
6d146cc0-b14a-41e6-80f6-6d0a0baf99d7
Adam
Adam2y ago
Don’t think there’s anything you can do here, I’ll tag in the team and see if it’s salvageable
Percy
Percy2y ago
Flagging this thread. A team member will be with you shortly.
Connor
ConnorOP2y ago
Thank you 🙂
Brody
Brody2y ago
you've tried restarting the database though right?
Connor
ConnorOP2y ago
Yes. Problem is I changed a configuration variable for DB to point to something that doesn't exist so now the DB won't start at all. It is stuck in an endless restart loop. I ended up creating a new DB and loading a backup from earlier today to restore functionality but I would like to get into this one at least so I can make sure there isnt any new data that needs to be merged into backup
Brody
Brody2y ago
thats no fun, team will be on this when they have the time
Ray
Ray2y ago
heya, we're aware of your issue, will follow up with a fix soon! do you know the original value of shared_preload_libraries/did you alter it previously?
Connor
ConnorOP2y ago
It should just be 'timescaledb'
ALTER SYSTEM SET shared_preload_libraries = 'timescaledb';
ALTER SYSTEM SET shared_preload_libraries = 'timescaledb';
@rayofbytes any update on this?
Unknown User
Unknown User2y ago
Message Not Public
Sign In & Join Server To View
Connor
ConnorOP2y ago
Thank You!
Want results from more Discord servers?
Add your server