a month ago
My PostgreSQL volume reached 99% capacity and now Postgres crashes with:
FATAL: could not write to file "pg_wal/xlogtemp.26": No space left on device
I have no backups and need to recover the database. Is there a way to temporarily increase storage or access the volume to free space without wiping it?
1 Replies
a month ago
Your Postgres volume is 500 MB with ~494 MB used. You can increase it up to 5 GB (the Hobby plan limit) via live resize in the volume settings, which will expand storage without wiping data. Since the volume is at near-100% capacity, the system will perform an offline resize with a brief restart to run data integrity checks. After resizing, redeploy the service and Postgres should recover normally.
Status changed to Awaiting User Response Railway • about 1 month ago
24 days ago
This thread has been marked as solved automatically due to a lack of recent activity. Please re-open this thread or create a new one if you require further assistance. Thank you!
Status changed to Solved Railway • 24 days ago