Request for Database Export Assistance - Migration from Railway

3 months 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

3 months ago

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


3 months ago

unfortuantely it got stoped today

1444056852886192400


3 months ago

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


3 months ago

1444058627508932600


3 months ago

undoable


3 months ago

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


3 months ago

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


3 months ago

on the bottom right side


3 months ago

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


3 months ago

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



3 months ago

1444064846965641200


3 months ago

1444064905060811000


avxo
PRO

3 months ago

Pay the bill bro


3 months ago

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


3 months 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 3 months ago


Loading...