2 months ago
I used to just enter a similar command in cmd and it worked, but now I get an error and can't do anything
pg_dump: error: connection to server at "reseau.proxy.rlwy.net" (66.33.22.224), port 31709 failed: Connection timed out (0x0000274C/10060)
Is the server running on that host and accepting TCP/IP connections?I tried using VPNs from different countries, but it didn't work
Pinned Solution
2 months ago
Try running this in console: pg_dump -U postgres -h localhost -d railway > dump.sql
25 Replies
2 months ago
This thread has been opened as a bounty so the community can help solve it.
Status changed to Open Railway • 2 months ago
2 months ago
Also, you can run pg_dump from the console tab of your service, then download the dump file directly from the filebrowser. It might be faster that way.
2 months ago
my database is crashing even though there is data in the variables, and I can't download the data because of this
2 months ago
Mounting volume on: /var/lib/containers/railwayapp/bind-mounts/f4a153fe-3292-418b-8f1a-05767b6079b4/vol_ofn60390g61cnd9l
ERROR: BOT_TOKEN not found in configurations
Mounting volume on: /var/lib/containers/railwayapp/bind-mounts/f4a153fe-3292-418b-8f1a-05767b6079b4/vol_ofn60390g61cnd9l
ERROR: BOT_TOKEN not found in configurations
although there is this token and it worked just yesterday, today when I wanted to transfer data to a local PC, it started giving this error
2 months ago
yes
2 months ago
You need to recreate your Postgres instance then.
- Delete the current Postgres service (Don't delete the volume)
- Right click on your canvas and create a new Postgres instance
- After it's deployed, drag the old volume onto the new instance to swap volumes (the new volume can be deleted)
2 months ago
So, without recreating, it won't be possible to download data from the database?
2 months ago
It's possible you accidentally ran railway up into your database service.
Either way, the image on your database service isn't what it's supposed to be, so you'd need to recreate the service.
2 months ago
and if I do something wrong, is it possible to roll back the changes?
2 months ago
The steps are pretty straightforward. It would be quite hard to accidentally delete your volume.
2 months ago
I've done a good job, but now how can I get the data from this database to make it work?
2 months ago
You can run pg_dump (2) from the console tab (1) by clicking on your database. You'll then be able to download the dump file from the filebrowser (3) below.
Attachments
2 months ago
for some reason, the file is downloaded empty, even though there is data
2 months ago
Or am I doing something wrong?
2 months ago
It's like you said
2 months ago
yes, maybe I'm doing something wrong
2 months ago
Try running this in console: pg_dump -U postgres -h localhost -d railway > dump.sql
2 months ago
Thank you very much you are the best
Status changed to Solved 0x5b62656e5d • 2 months ago
