a year ago
I am getting this error:
2024-03-29 22:10:54.413 UTC [8] FATAL: could not write lock file "postmaster.pid": No space left on device
but i can't access the database with psql or anything to try and remove the uneccessary data. This is resulting in downtime for us.
0 Replies
a year ago
hey @themkrage what is the current size of your volume?
50GB
It looks like the recusrive pg query i ran filled it. It's not like the database has 50GB's of content, just that one query appears to have filled the container
i don't see an option to increase the cap, and im not sure how to clear the "in-progress" query and data
i can't connect to the database either, so i can't run VACUUM
, which i think would fix this
a year ago
Okay ill do my best to get a team member here asap, in the mean time please provide your project id
a year ago
Hello, working on expanding your cap now
a year ago
One sec
a year ago
Okay, try now
a year ago
Should be up to 100 GB
thank you. Running vacuum brought our disk usage back to normal expected level
For future reference, is there no way to access a database that has hit the disk usage cap?
a year ago
correct
a year ago
postgres more or less locks itself up when it runs out of disk
a year ago
there is nothing that i am personally aware of