2 months ago
I have a Postgres deployment
Under settings -> Public Networking, I enabled it so i got XXXXXXX.up.railway.app and port 5432
I also have POSTGRES_USER and POSTGRES_PASSWORD string collected
I inputted all this info to pgAdmin -> Create Database Connection
It got the timed out error. Looks like the public domain can't be reached.
i was able to connect with another domain name like 2 days ago. But 2 days ago, I delete that previous public domain but I needed again and I ran into this issue.
Pinned Solution
2 months ago
you're using a public domain which only works for http. postgres needs tcp proxy instead
go to your postgres service settings -> networking, delete that .up.railway.app domain, then click "add tcp proxy" and set port 5432. railway will give you a proxy.rlwy.net address with a random port. use those credentials in pgadmin
they can't both be active at the same time ;that's why deleting and recreating the domain broke it
1 Replies
2 months ago
This thread has been marked as public for community involvement, as it does not contain any sensitive or personal information. Any further activity in this thread will be visible to everyone.
Status changed to Open brody • 2 months ago
2 months ago
you're using a public domain which only works for http. postgres needs tcp proxy instead
go to your postgres service settings -> networking, delete that .up.railway.app domain, then click "add tcp proxy" and set port 5432. railway will give you a proxy.rlwy.net address with a random port. use those credentials in pgadmin
they can't both be active at the same time ;that's why deleting and recreating the domain broke it
Status changed to Solved Anonymous • 2 months ago
Status changed to Solved brody • 2 months ago