Unable to connect to fresh postgres app from Dbeaver

[SergioDev]

Hi, I just created a postgres app, I can connect with psql and another app deployed in fly, however, pgadmin, dbeaver and other clients hang trying to connect to this instance.

Could you help?

[ignoramous]

I don’t think Fly-automated Postgres (I am not a fan) is publicly accessible.

You’d need to use fly-proxy, if you’re not already:

How can I connect my production fly database to GUI e.g. TablePlus

If you’re using Fly’s managed Postgres: You could connect with the flyctl proxy¹ command forwarding connections to the VM where the database process is up and running. Ref: Public URL / IP for Postgres Cluster - #15 by kurt Though people have run into issues with that setup: Connection timeout when trying to connect to Postgres cluster from outside fly If you’re coming from the Heroku world, this guide might come in handy: Migrating from Heroku Postgres to Fly Postgres: A Complete Guide If you…

---

As for connecting to Postgres from another Fly app (in the same org), are you doing what’s suggested? Connect From a Fly App · Fly Docs

[SergioDev]

Hi, I have tried using proxy redirection, and also using wireguard, but none of the methods work

[ignoramous]

Strange. Both apps in the same Fly org, correct? And the Postgres app is up and running (docs)?

What’s the output of fly doctor?

Try connecting after exec’ing fly wg websockets enable (ref).

Alternatively, it looks like you can assign public IPs to Fly-automated Postgres (docs) for $2/mo (IPv4).