a month ago
Hi Railway team,
My PostgreSQL instance (postgres-production-3cfc.up.railway.app) is stuck in a recovery loop with the following error in the logs:
pgsql
Kopiuj
Edytuj
PANIC: could not write to file "pg_logical/replorigin_checkpoint.tmp": No space left on device
Because of the lack of disk space, the database cannot complete recovery and immediately aborts, so I can’t connect to it to extract any data. I need to recover my n8n workflows, which are stored in the workflow_entity table.
Could you please help with one of the following as soon as possible:
Temporarily increase the storage/quota for this database instance so it can finish recovery and become accessible, allowing me to export the workflow definitions.
OR
Take a snapshot or dump of the underlying data directory (or otherwise provide a copy of the data files) so I can mount/restore it elsewhere and extract the workflow_entity records.
I can provide any additional details or follow any steps you recommend. This is impacting production workflow continuity, so a quick assist would be greatly appreciated.
Thank you,
4 Replies
a month ago
Hey there! We've found the following might help you get unblocked faster:
🧵 PostgreSQL crashed: No space left on device, n8n workflows inaccessible"
🧵 🧷 Title: Help! PostgreSQL Crashing – “No space left on device” (Hobby Plan)
If you find the answer from one of these, please let us know by solving the thread!
a month ago
This thread has been marked as public for community involvement, as it does not contain any sensitive or personal information. Any further activity in this thread will be visible to everyone.
Status changed to Open chandrika • 28 days ago
a month ago
What's the current size of the volume ?
a month ago
a month ago
It seems the OP has figured out the solution, OP was on Hobby plan when the bounty was created, Now it's Pro.