Failing pg_restore of a small DB
petedermott
HOBBYOP

22 days 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](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

0 Replies

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


petedermott
HOBBYOP

22 days ago

It's definatly 5432 in the dashboard

1438294227518750700


petedermott
HOBBYOP

22 days ago

Is there some external port that I'm missing?


petedermott
HOBBYOP

22 days ago

Oh wait, you can get it from the public url


petedermott
HOBBYOP

22 days ago

Got it, thanks!




passos
MODERATOR

22 days ago

!t


passos
MODERATOR

22 days ago

This thread has been escalated to the Railway team.

Status changed to Awaiting Railway Response passos 22 days ago


passos
MODERATOR

22 days ago

sorry, wrong command


Status changed to Solved passos 22 days ago


Status changed to Solved passos 22 days ago


Loading...