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

what was the command ran to take the backup?

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

im sorry but that doesnt quite answer my question

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

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 pgrestore / pgdump 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 pgdump and pgrestore 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