Unable to connect remotely to my Postgres instance using dedicated IPv4 fly.io address

1

I’m able to connect to my Postgres instance:

flyctl postgres connect -a my-app
Connecting to fdaa:3:ba4:a7b:a1:86fc:625f:2... complete
psql (15.3 (Debian 15.3-1.pgdg120+1))
Type "help" for help.

postgres=#

However, I’m unable to connect using pgadmin or psql. I have a dedicated IPv4 and try with this:

psql -h <fly.io dedicated ip> -p 5432 -U ,user> -d <db>

psql: error: connection to server at "168.220.84.24", port 5432 failed: SSL SYSCALL error: Undefined error: 0
connection to server at "<ip>", port 5432 failed: server closed the connection unexpectedly
	This probably means the server terminated abnormally
	before or while processing the request.

I’ve been following the following instructions: External Connections · Fly Docs

However, when I issue the following command:

fly image show --app my-app

I don’t see the output expected in the article. Instead I get four images listed in the form:

9080e45dc51998	registry.fly.io	<my-app> deployment-01HASAQ4W4CX8EP0P2F0ZKSEFF	N/A    	sha256:e96c3c09072f7d5c2aa6b24152b6af344a1e89226ffd98171e5609c47642810b	org.opencontainers.image.ref.name=ubuntuorg.opencontainers.image.version=22.04

I deployed via fly deploy and nothing seems off in the Monitor page, but I’m not sure if something else is needed.

Any ideas? Thanks!

2

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.