Worker out of memory
pierrevhm
HOBBYOP

4 months ago

Hello Railway
I'm experiencing a critical issue with my PostgreSQL service and need help recovering my data before it's lost.
Problem Summary:

My PostgreSQL service keeps crashing with "No space left on device" errors
Database system shuts down during startup/recovery process
n8n application can no longer connect to the database
All my n8n workflows and credentials are stored in this PostgreSQL instance

What I've tried:

Upgraded to paid plan (8GB storage allocated)
Multiple redeployments
Configuration fixes
The volume appears to be in a corrupted state despite having sufficient storage

Current Status:

PostgreSQL service: CRASHED (won't start)
n8n service: INACCESSIBLE (can't connect to DB)
Data: Trapped in persistent volume
Risk level: HIGH (critical workflow data at risk)

What I need:

Help recovering data from the persistent PostgreSQL volume
Either mount the existing volume on a new PostgreSQL instance
Or extract the data so I can import it into a fresh database

Service Details:

Service Type: PostgreSQL
Plan: Paid (8GB storage)

This contains months of work in n8n workflows that cannot be recreated. Any assistance would be greatly appreciated!
Thank you for your help šŸ™

Solved

0 Replies

pierrevhm
HOBBYOP

4 months ago

d13ecc4d-e7d3-4d0e-a66b-4019ebfd77ab


uxuz
MODERATOR

4 months ago

Hey @pierre_vhm, the hobby plan has a 5GB limit on each volume. You will have to grow your volume beyond 5GB if you have upgraded to the pro plan.


pierrevhm
HOBBYOP

4 months ago

@uxuz ok I see, but postgres doesn't even use all my memory, I don't understand

1404078164153598200


pierrevhm
HOBBYOP

4 months ago

it's the connection with my database who crash

1404078549891158000


uxuz
MODERATOR

4 months ago

Hey, can you click on the volume, it's the part underneath your database. In my case, it is called pgvolume.

1404080494639054800


pierrevhm
HOBBYOP

4 months ago

it's here ?

1404081046244556800
1404081046508667000


uxuz
MODERATOR

4 months ago

Sorry, I wasn't clear enough, I meant this part of the service.

1404081836094914600


pierrevhm
HOBBYOP

4 months ago

Ah ok lol sorry, mine is called hopeful-volume
Here is the information I find in it, I probably need to increase the 500mb?

1404082476263018500
1404082476648759300


uxuz
MODERATOR

4 months ago

You are right, please grow your volume to 5GB (your plan's limit), this should solve the issue.


pierrevhm
HOBBYOP

4 months ago

OK, i have this message, it's ok ?
Won't I lose all my workflows in N8N?


pierrevhm
HOBBYOP

4 months ago

1404084068353704200


uxuz
MODERATOR

4 months ago

No, you won't lose your data. This is just a warning that you can't downsize your volume, such as from 5GB to 1GB. Keep in mind that you are only getting charged for what you use and not what the volume's new limit is.


pierrevhm
HOBBYOP

4 months ago

Ok nice I'll try then


pierrevhm
HOBBYOP

4 months ago

bro thank you so much, it's good for me šŸŽ†


uxuz
MODERATOR

4 months ago

Great, I'll mark this as solved if you don't have any further questions.


pierrevhm
HOBBYOP

4 months ago

yes it's good thank


uxuz
MODERATOR

4 months ago

!s


Status changed to Solved uxuz • 4 months ago


Loading...