a month ago
I have tried to back up remote postgres railway database locally but it stucks, I have followed the blog
https://blog.railway.com/p/postgre-backup
21 Replies
a month ago
Why does the slug lack an s
a month ago
Are you trying to do a one-time backup or automated backups?
a month ago
For automated backups, see this:
For a one-time backup, what's the issue you're having with the blog post above?
I am looking for one time local backup, and restore to other services not the native automated one
a month ago
The only thing you need is to run the command: pg_dump -d postgresql://user:password@host:port/db_name -Fc -f /path/to/file.backup .
You can run it locally once or automate it to get your backup.
a month ago
was commenting towards the link lacking an s in the slug, postgre
Any docs resource regarding that, I have not found any manual backup , restore related recent resources regarding the process
a month ago
The blogpost you saw above is still valid, did you try to follow the steps? What issues are you encountering?
a month ago
Try the following command:
pg_dump -d -Fc -f /path/to/file.backupFor the database URL part, substitute it with the variable named DATABASE_PUBLIC_URL on your Postgres service in Railway
a month ago
Also, if you're looking for an easy method, Railway offers backups if you're on the Pro Plan.
I have go this one but I need local backup of the remote database
seems above command is not working
is this command is working one?
I have tried the above command as well as one from the blogs, but it stucks as usual
a month ago
Try this one:
pg_dump -v -d -Fc -f dump.backupThis command also ,stuck, Waiting for last 5 minutes after applying the command
I have tested the backup and restore related command 2 years back, the the command was working! but not now.Whats the issue!


a month ago
it seems that you're able to connect to your database, how big is your data? maybe it takes awhile to dump
a month ago
could be really slow, even more if you're far away from the database (latency and all).
a month ago
Maybe that could be reduced if you spin up an Ubuntu service in the same Railway project, SSH into it, and dump it over private networking. Then you could use a web server of some sort to download it.