R
Railway•2w ago
law

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
Percy
Percy•2w ago
Project ID: N/A
law
law•2w ago
N/A
Brody
Brody•2w ago
what is the exact command you ran
law
law•2w ago
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.
Brody
Brody•2w ago
try different variations of that command
Want results from more Discord servers?
Add your server
More Posts
PHP: 504 Time-outIt's my first time deploying an PHP app, as I'm trying to pass an interview. They sent me a custom, PostgreSQL Custom Docker Image With Volume Entrypoint QuestionsHello, I have a Docker Image for PSQL with a volume attatched to that service that I am trying to ruSync environment issueI am unable to sync an environment, getting an error message with "Error: {Environemtn name} changesdashboard keeps showing 404 during normal useI am trying to add a shared variable and every time I open up the "production" environment to add myDjango APi 502 Bad Gateway and CORSi am getting CORS Error also i setup my cors correctly and plus net::ERR_FAILED 502 (Bad Gateway) Error: P1001: Can't reach database server at `postgres.railway.internal:5432`It was working fine past 2 weeks now when I opened it is not opening and throwing this error. GettinLost Access to my GithubMy phone and laptop were stolen and i cant access my github because of 2FA as i cant locate where i App sleeping returns 502 Bad Gateway when the app is being resumedAfter that error occurs, when I refresh the page again the app responds normally and there is nothinCustom Domain issueI bought a domain at godaddy and used the custom domain spiritiitg.in on render but when i go at the20 euro higher paymentI received a payment of 27/28 euros on railway, I put the credit limit, why did I pay that price ins