PostgreSQL instance

Anonymous
PRO

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,

$10 Bounty

4 Replies

Railway
BOT

a month ago


chandrika
EMPLOYEE

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


smolpaw
HOBBYTop 5% Contributor

a month ago

What's the current size of the volume ?


phoenixauro
HOBBY

a month ago

You are running out of space. Click the volume and in settings grow the volume to a larger size.



smolpaw
HOBBYTop 5% Contributor

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.


PostgreSQL instance - Railway Help Station