I need help with postgres restore database | Railway | Page 1

terse fractal Oct 24, 2024, 3:32 PM

#

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.

upbeat flameBOT Oct 24, 2024, 3:32 PM

#

Project ID: 53b9fe5c-d166-46c5-bd1a-8280edc67251

terse fractal Oct 24, 2024, 3:33 PM

#

53b9fe5c-d166-46c5-bd1a-8280edc67251

runic viper Oct 24, 2024, 3:40 PM

#

what was the command ran to take the backup?

terse fractal Oct 24, 2024, 3:43 PM

#

pg_restore -U postgres -h autorack.proxy.rlwy.net -p 28543 -W -F t -d railway SCHOOL_MANAGER

runic viper Oct 24, 2024, 3:50 PM

#

im sorry but that doesnt quite answer my question

terse fractal Oct 24, 2024, 3:52 PM

#

pg_dump -U postgres -h monorail.proxy.rlwy.net -p 30383 -W -F t railway > SCHOOL_MANAGER

terse fractal Oct 24, 2024, 4:43 PM

#

How's it going?

runic viper Oct 24, 2024, 5:36 PM

#

what version of pg_dump are you using?

terse fractal Oct 24, 2024, 5:47 PM

#

16.3

#

runic viper Oct 24, 2024, 5:57 PM

#

and what about pg_restore?

terse fractal Oct 24, 2024, 5:58 PM

#

#

same

runic viper Oct 24, 2024, 5:59 PM

#

i cant reproduce the issue with pg_restore / pg_dump 16.x, i ran the same commands you gave me

terse fractal Oct 24, 2024, 6:00 PM

#

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

runic viper Oct 24, 2024, 6:03 PM

#

i didnt take a backup of your database lol

terse fractal Oct 24, 2024, 6:10 PM

#

Then does my database create the issue?

runic viper Oct 24, 2024, 6:12 PM

#

i assume its a bad file

terse fractal Oct 24, 2024, 6:12 PM

#

how come?

runic viper Oct 24, 2024, 6:14 PM

#

because restoring from the file doesnt work

terse fractal Oct 24, 2024, 6:28 PM

#

Can I swap postgres database between prod and dev environment

runic viper Oct 24, 2024, 6:32 PM

#

nope, you would want to use pg_dump and pg_restore for that

terse fractal Oct 25, 2024, 4:12 AM

#

#

I made progress with an new error

runic viper Oct 25, 2024, 4:13 AM

#

you need to use the public host and port

terse fractal Oct 25, 2024, 4:14 AM

#

#

this one right?

runic viper Oct 25, 2024, 4:14 AM

#

thats the internal host

terse fractal Oct 25, 2024, 4:15 AM

#

where can I find it?

#

#

why it has two ports?

runic viper Oct 25, 2024, 4:16 AM

#

external and internal

terse fractal Oct 25, 2024, 4:18 AM

#

#

procceed with an new error

runic viper Oct 25, 2024, 4:19 AM

#

i honestly dont know, unfortunately theres not all that much i can do here as we cant really provide support for 3rd party software

#I need help with postgres restore database