Data tab can't connect to Postgres database
ciplazar
FREEOP

9 months ago

If I go to the Data tab of my deployed Postgres db it gets stuck at the Database Connection stage (with API errors like the one in the attached screenshot) and doesn't display any tables -- my application can connect to the db and works with no issues, though. I'm using Railway's Postgres template, except I've switched the deployment to v17 (https://github.com/railwayapp-templates/postgres-ssl/pkgs/container/postgres-ssl/369324510?tag=17) instead of the default v16, and I've deleted the db's public URL. I've tried redeploying the db, but I'm seeing the same issue.

Attachments

2 Replies

If you don't have a public URL, you won't be able to connect to the data tab on your Postgres.


ciplazar
FREEOP

9 months ago

Ah, I see! Thanks! I had assumed that the UI would be accessing the DB via the private network, but I guess the UI is an "external" thing that needs to access it via the public URL?

Hmm, then I might just forego using the DB web UI, since I'd rather not have the server exposed via a public URL.

It might be worth adding a descriptive error message to the UI for this particular case! Or a warning message when someone deletes the public URL env var.


Loading...