Postgres Backup Question
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.
5 Replies
Project ID:
N/AN/A
what is the exact command you ran
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.try different variations of that command