Why does the slug lack an s

Are you trying to do a one-time backup or automated backups?

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

can you elaborate?

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

The blogpost you saw above is still valid, did you try to follow the steps? What issues are you encountering?

yes I have followed the steps it stuck infinitely

This one is also have same issue

Try the following command:

pg_dump -d  -Fc -f /path/to/file.backup

For the database URL part, substitute it with the variable named DATABASE_PUBLIC_URL on your Postgres service in Railway

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

Try this one:

pg_dump -v -d  -Fc -f dump.backup

This 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!

it seems that you're able to connect to your database, how big is your data? maybe it takes awhile to dump

After 30 minutes still file size was 0 kb, then I aborted

could be really slow, even more if you're far away from the database (latency and all).

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.