Postgres Data UI infinitely loading
shreyas-v-agnihotri
HOBBYOP

9 months ago

Trying to view my Postgres DB through the embedded Postgres Data UI view. It has green checks next to Deployment Online and Required Variables but then just loads infinitely when trying to render the DB interface.

I saw other support tickets said to set up public networking and a TCP proxy and I did that + redeployed, but the same issue is happening. I'm also not able to use the DATABASE_URL from variables (which uses the TCP proxied domain as a host) with either the default or forwarded port to connect via a normal DB explorer — it similarly spins infinitely.

Any help would be appreciated!

Solved

5 Replies

jake
EMPLOYEE

9 months ago

Are you able to connect to it using say, the postgres CLI?

Status changed to Awaiting User Response Railway • 9 months ago

shreyas-v-agnihotri
HOBBYOP

9 months ago

No, it just hangs: 

psql postgres://metabase:pw@shinkansen.proxy.rlwy.net:6000/metabase

psql: error: connection to server at "shinkansen.proxy.rlwy.net" (35.212.23.137), port 6000 failed: Operation timed out

	Is the server running on that host and accepting TCP/IP connections?

Status changed to Awaiting Railway Response Railway • 9 months ago

angelo-railway
EMPLOYEE

9 months ago

That seems to be the incorrect port of your DB.

Status changed to Awaiting User Response Railway • 9 months ago

shreyas-v-agnihotri
HOBBYOP

9 months ago

I changed the port after I posted because I was trying to get it to work. But to be clear: none of the ports listed in this image work (5432, 25266, 2923). Can you help?

Attachments

image.png

Status changed to Awaiting Railway Response Railway • 9 months ago

jake
EMPLOYEE

9 months ago

You were using the HTTP proxy and then also the wrong port

I've updated the proxy. You should be good to go now if you use that endpoint

Status changed to Awaiting User Response Railway • 9 months ago

Railway
BOT

4 months ago

This thread has been marked as solved automatically due to a lack of recent activity. Please re-open this thread or create a new one if you require further assistance. Thank you!

Status changed to Solved Railway • 4 months ago

Loading...