Failing pg_restore of a small DB
petedermott
HOBBYOP

4 months ago

Hi! Newbish question, I'm trying to restore a postgresql dump to railway, the documentation says that the domain will look something like containers-us-west-15.railway.app but the domain in my dashboard looks like mainline.proxy.rlwy.net and the attempted restoration always times out (error below). It's a very small dump so I can't see any reason for this, am I missing something?

pg_restore: error: connection to server at "mainline.proxy.rlwy.net" (66.33.22.234), port 5432 failed: Operation timed out Is the server running on that host and accepting TCP/IP connections?

Solved$10 Bounty

9 Replies

im pretty sure the proxy port is not 5432, can you double check your database networking settings for the correct port?


petedermott
HOBBYOP

4 months ago

It's definatly 5432 in the dashboard

1438294227518750700


petedermott
HOBBYOP

4 months ago

Is there some external port that I'm missing?


petedermott
HOBBYOP

4 months ago

Oh wait, you can get it from the public url


petedermott
HOBBYOP

4 months ago

Got it, thanks!




4 months ago

!t


4 months ago

This thread has been escalated to the Railway team.

Status changed to Awaiting Railway Response passos 4 months ago


4 months ago

sorry, wrong command


Status changed to Solved passos 4 months ago


Status changed to Solved passos 4 months ago


Loading...