10 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:
• pg_dump from my local machine (connection refused)
• pg_dump 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 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?
10 months ago
unfortuantely it got stoped today
10 months ago
See if you can upgrade to the Free plan by going into that suggested link
10 months ago
10 months ago
undoable
10 months ago
You will need to downgrade to the Free plan to spin up your DB again or upgrade to Hobby.
10 months ago
i cant downgrade as u can see it says error already has a subscription
10 months ago
on the bottom right side
10 months ago
upgrading doesnt make sense because i want one time download , my backend is running on own vps now
10 months ago
Could u check your workspace billing area to see if you still got an active plan?
10 months ago
10 months ago
10 months ago
10 months ago
Pay the bill bro
10 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
10 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 • 10 months ago