Postgres Backup Question

Anonymous

TRIALOP

a year ago

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?

5 Replies

Anonymous

TRIALOP

a year ago

N/A

brody

EMPLOYEE

a year ago

what is the exact command you ran

Anonymous

TRIALOP

a year ago

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

Anonymous

TRIALOP

a year ago

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

brody

EMPLOYEE

a year ago

try different variations of that command