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