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:
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