I am creating a database app to connect to externally (outside Flyio). Of course, I’m following the External Connections instructions. I’m trying to use DBeaver to connect to it.
I’ve already done the proxy method and that worked, but I’m trying to specifically connect to my database without doing that. To proxy, I can run:
fly proxy 25432:5432 -a <my app name>
And for credentials:
Host: localhost
Database: postgres
Username: postgres
Password: <password from app creation>
I have allocated an IPv6 public address, verified the .toml file, and deployed successfully. However, when I run:
psql "sslmode=require host=<app name>.fly.dev dbname=postgres user=postgres"
I get the error:
psql: error: could not translate host name "<app name>.fly.dev" to address: Unknown host
And further when I try to connect via DBeaver using these credentials:
Host: <app name>.fly.dev
Database: postgres
Username: postgres
Password: <password from app creation>
I get a generic “The connection attempt failed.” error.
I have seen this work with IPv4, but it seems like it should work with IPv6. Is there anything I’m missing here?