a month ago
Please help, I was looking at the database tab in the in my pg db when I decided to click the config, i was looking at the analysis on the db and it recommend i installed pgstatsstatements and now I can't view or connect to my db to fix the problem.
Attachments
13 Replies
a month ago
Please don't ping team members/conductors, please look at #🛂|readme 5)
a month ago
I assume that this is related to https://discord.com/channels/713503345364697088/1467207292100415771, in short SSH into your service and remove the quotes. You can temporarily change your service's start command to something like sleep 100000000, so that there is enough time for you to SSH into it before it crashes.
a month ago
Even after changing the start command to sleep 10000000000?
a month ago
Can you share what was the fix to your issue?
Well.. I ssh'd into the machine after applying running sleep 100000000 in the start command, once inside the vps, i run this command sed -i.bak 's/^shared_preload_libraries/#shared_preload_libraries/' /var/lib/postgresql/data/pgdata/postgresql.auto.conf. It commented out the the line in the postgres config file responsible for the crash
Status changed to Solved medim • about 1 month ago