Railway•13mo ago

pg_restore Connection refused

When I am trying to run pg_restore command, I get connection refused error. I did pg_dump from 1 environment, and I am trying to restore it to another environment, since I am trying to deploy into production. Error:

pg_restore -U postgres -h containers-us-west-{code}.railway.app -p {port} -W -F t -d railway {backup_name}
Password:
pg_restore: error: connection to server at "containers-us-west-{code}.railway.app" {ip}, port {port} failed: Connection refused {code}
        Is the server running on that host and accepting TCP/IP connections?

pg_restore -U postgres -h containers-us-west-{code}.railway.app -p {port} -W -F t -d railway {backup_name}
Password:
pg_restore: error: connection to server at "containers-us-west-{code}.railway.app" {ip}, port {port} failed: Connection refused {code}
        Is the server running on that host and accepting TCP/IP connections?

I verified that password and everything was correct, tried removing firewall and antivirus.

2 Replies

Percy•13mo ago

Project ID: N/A

Wasabi23901OP•13mo ago

N/A

Gaming

Programming

pg_restore Connection refused