PSQL backup taking to long
imant1
FREEOP

3 months ago

Hi, i have a manual backup in a psql service that i'm trying to restore.

The backup is 1.6 GB.

How much time can it take to restore?

It's been like 50 minutes, and the volume is still in "Restoring backup..." state.

This is the project url https://railway.com/project/8d610438-f424-474c-9f20-c0a84315f524/service/a7633bc9-cd3d-4c51-b56c-dc01b50825a9/backups?environmentId=32db7a37-2836-436f-b8cc-60a7b107720d&projectId=8d610438-f424-474c-9f20-c0a84315f524&serviceId=a7633bc9-cd3d-4c51-b56c-dc01b50825a9

$10 Bounty

1 Replies

Status changed to Awaiting Railway Response Railway 3 months ago


oliverstrubin
HOBBY

3 months ago

I can't see your project but, I wouldn’t worry too much yet. Railway backups are restored at the volume level, so it’s not the same as restoring a normal pg_dump where data is just streamed back into Postgres. It’s pretty much recreating the entire volume and then starting the database from that snapshot. I’d probably give it up to 90 minutes before being concerned. If it goes past 2 hours, then it might be worth cancelling the restore (if you can) and trying again.


Welcome!

Sign in to your Railway account to join the conversation.

Loading...