I need help with postgres restore database
I followed this article but came with an error
https://blog.railway.app/p/postgre-backup
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.
35 Replies
Project ID:
53b9fe5c-d166-46c5-bd1a-8280edc6725153b9fe5c-d166-46c5-bd1a-8280edc67251
what was the command ran to take the backup?
pg_restore -U postgres -h autorack.proxy.rlwy.net -p 28543 -W -F t -d railway SCHOOL_MANAGER
im sorry but that doesnt quite answer my question
pg_dump -U postgres -h monorail.proxy.rlwy.net -p 30383 -W -F t railway > SCHOOL_MANAGER
How's it going?
what version of pg_dump are you using?
16.3
and what about pg_restore?
same
i cant reproduce the issue with pg_restore / pg_dump 16.x, i ran the same commands you gave me
can you give me the file/
the backup file
I used the file which I backed up 2 months ago, it works just fine, but not the new one
i didnt take a backup of your database lol
Then does my database create the issue?
i assume its a bad file
how come?
because restoring from the file doesnt work
Can I swap postgres database between prod and dev environment
nope, you would want to use pg_dump and pg_restore for that
I made progress with an new error
you need to use the public host and port
this one right?
thats the internal host
where can I find it?
why it has two ports?
external and internal
procceed with an new error
i honestly dont know, unfortunately theres not all that much i can do here as we cant really provide support for 3rd party software
Well it finished with a warning the data was restored safely, thanks anyway