Request for Database Export Assistance - Migration from Railway
avilio
FREEOP

10 days ago

Need help exporting Postgres database for migration

Hi, I'm migrating my Strapi app from Railway to my own VPS. I need to export my Postgres database to move my data.

Problem: I can't connect to export the database. When I try pg_dump from my computer or VPS, Railway closes the connection. The Backups feature requires Pro plan, which I don't have.

What I tried:
• pgdump from my local machine (connection refused) • pgdump from my VPS (connection refused)
• Railway CLI railway run pg_dump (doesn't work)
• Checked dashboard for export options (none found)
What I need:
• A way to export my database (one-time)
• Or temporary access to enable external connections
Details:
• Project: 360-marketing
• Service: Postgres
• Database: railway
• Plan: Hobby

Can someone help me export the database or enable temporary access? Thanks.

Solved

16 Replies

medim
MODERATOR

10 days ago

Hi, the best way to do this is through pg_dump, what's the current status of your deployed DB? is it running?


avilio
FREEOP

10 days ago

unfortuantely it got stoped today

1444056852886192400


medim
MODERATOR

10 days ago

See if you can upgrade to the Free plan by going into that suggested link


avilio
FREEOP

10 days ago

1444058627508932600


avilio
FREEOP

10 days ago

undoable


medim
MODERATOR

10 days ago

You will need to downgrade to the Free plan to spin up your DB again or upgrade to Hobby.


avilio
FREEOP

10 days ago

i cant downgrade as u can see it says error already has a subscription


avilio
FREEOP

10 days ago

on the bottom right side


avilio
FREEOP

10 days ago

upgrading doesnt make sense because i want one time download , my backend is running on own vps now


medim
MODERATOR

10 days ago

Could u check your workspace billing area to see if you still got an active plan?



avilio
FREEOP

10 days ago

1444064846965641200


avilio
FREEOP

10 days ago

1444064905060811000


avxo
PRO

10 days ago

Pay the bill bro


avilio
FREEOP

10 days ago

lol i pay because i want get some databack just to migrate it later to my own vps later that doesnt any sense


medim
MODERATOR

10 days ago

As others have said, you have a unpaid invoice.
That's the reason you can't spin up your DB or downgrade to the Free plan.


Status changed to Solved medim 9 days ago


Loading...