Postgres Backup Question | Railway | Page 1

somber gale Jun 24, 2024, 6:25 PM

#

https://blog.railway.app/p/postgre-backup

I am following the blog post but I had a question using pg_restore.

Do I use railway CLI to use the pg_restore command? I tried to do it locally but had a zsh: permission denied error. What is the recommended way to restore from AWS?

Railway Blog

How to Backup and Restore Your Postgres Database

In this post, we will go over the process of backing up and restoring your Postgres database hosted on Railway.

viscid blazeBOT Jun 24, 2024, 6:25 PM

#

Project ID: N/A

somber gale Jun 24, 2024, 6:25 PM

#

N/A

restive oracle Jun 24, 2024, 6:31 PM

#

what is the exact command you ran

somber gale Jun 24, 2024, 6:36 PM

#

sudo pg_restore -U postgres -h r blah.proxy.rlway.net -p 00000 -d railway -v /Users/***/pgdump/backup.dump

#

Would like to not mess with my permission settings too much if possible.

#Postgres Backup Question