psql: error: connection to server at "localhost" (::1), port 5432 failed: FATAL: the database system is in recovery mode

sandxru

HOBBYOP

11 days ago

I am getting this error.

Database first crashed I believe because of ran out of space. Now it says recovery mode. I try restart and redeploy but still not working.

How to fix this without losing data?

$10 Bounty

3 Replies

Railway

BOT

11 days ago

Hey there! We've found the following might help you get unblocked faster:

If you find the answer from one of these, please let us know by solving the thread!

ray-chen

EMPLOYEE

11 days ago

Increase the size of your volume; the re-deploy initiated by it should work

Status changed to Awaiting User Response Railway • 11 days ago

ray-chen

Increase the size of your volume; the re-deploy initiated by it should work

sandxru

HOBBYOP

11 days ago

Thanks!

Another question.

I pruned the execution logs from the PostgreSQL database. Since PostgreSQL doesn’t physically delete records but only marks the space as available, am I still billed for the total physical disk usage if it hasn’t been vacuumed?

Do I need to run a VACUUM FULL to actually reduce storage costs?

Status changed to Awaiting Railway Response Railway • 11 days ago