How can I access the database from an external IP

1

All the addresses are app-name-postgres.internal

Is it possible to access postgres from Metabase or some other external IP?

1 Like
2

Our Postgres databases aren’t open to the internet by default. If you can run Metabase in the same Fly org, it’ll be easy to connect over the private network.

Otherwise, here are some more details: How can I connect to my Postgres from Metabase, and TablePlus? - #4 by kurt

1 Like
3

The instructions at the aforementioned link, as well as here under “configure an external service”, don’t seem to work for fly machines, only nomad apps.

e.g.

fly deploy -c fly.db.toml -a <db-app-name> --image flyio/postgres:14.6
==> Verifying app config
--> Verified app config
==> Building image
Searching for image 'flyio/postgres:14.6' remotely...
image found: img_0lq747j0ym646x35
==> Creating release
Error This operation requires the 'nomad' app platform. This app was created for the  'machines' platform.

How does one go about doing this on the machines platform?

1 Like