My production database just failed.
kennymark
PROOP

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.

Screenshot_2026-02-08_at_19.45.02.png

Attachments

Solved

13 Replies

kennymark
PROOP

a month ago

I need this fixed asap


kennymark
PROOP

a month ago

@Medim can I please get some help


a month ago

Please don't ping team members/conductors, please look at #🛂|readme 5)


kennymark
PROOP

a month ago

Sorry


kennymark
PROOP

a month ago

Any update?


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.


kennymark
PROOP

a month ago

I can't ssh, as the server is entirely crashing


a month ago

Even after changing the start command to sleep 10000000000?


kennymark
PROOP

a month ago

Its now working.. I am in the machine. I


kennymark
PROOP

a month ago

Thanks


a month ago

Can you share what was the fix to your issue?


kennymark
PROOP

a month ago

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


kennymark
PROOP

a month ago

Thats all


Status changed to Solved medim about 1 month ago


Loading...