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.
16 Replies
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?
10 days ago
unfortuantely it got stoped today

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

10 days ago
undoable
10 days ago
You will need to downgrade to the Free plan to spin up your DB again or upgrade to Hobby.
10 days ago
i cant downgrade as u can see it says error already has a subscription
10 days ago
on the bottom right side
10 days ago
upgrading doesnt make sense because i want one time download , my backend is running on own vps now
10 days ago
Could u check your workspace billing area to see if you still got an active plan?
10 days ago

10 days ago

10 days ago
Pay the bill bro
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
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