Unable to connect to Postgres using pgxpool

[surahman]

Hi,

I've been using pgx for a while without issues but I am running into an issue with pgxpool. Whilst trying to open a connection to a vanilla Postgres Docker container I get connection reset and EOF errors. I cannot put my finger on what I am missing and I am hoping someone can guide me as to what's going wrong.

The code snippet of interest is here:
https://github.com/surahman/FTeX/blob/629098f10933086fcc7cbb8fcaae6d99d9bbc225/pkg/postgres/postgres.go#L74-L99

All this code does is parse the DSN into the pgxpool.Config and then creates a new connection pool. Following this, the connection runs a basic SELECT 1; query to verify the connection. The port and address are correct because I get a connection refused error without them. I have tested the login credentials by logging into the psql shell in the container. Setting incorrect credentials does not generate errors in the pgxpool client which makes me believe the process never reaches the authentication check.

The errors I get vary between the two below:

Received unexpected error: failed to connect to `host=127.0.0.1 user=postgres database=ft-ex-db-test`: failed to receive message (read tcp 127.0.0.1:48658->127.0.0.1:6432: read: connection reset by peer)


Received unexpected error: failed to connect to `host=127.0.0.1 user=postgres database=ft-ex-db-test`: failed to receive message (unexpected EOF)

The DSN string being used:

user=postgres password=postgres host=127.0.0.1 port=6432 dbname=ft-ex-db-test connect_timeout=6000 sslmode=disable

[surahman]

Found my issue: internal container port mapping was incorrect.