Unable to connect to PG using SSL

[dkadetov]

Describe the bug I seem to have a similar problem when trying to use verify-full SSL mode

Steps to reproduce Set up a connection to Postgres using verify-full sslmode and a root certificate

?sslmode=verify-full&sslrootcert=/psql-root.crt

Expected behavior Connection successfully established

pgSCV startup options

PGSCV_LISTEN_ADDRESS: 0.0.0.0:9890
PGSCV_AUTOUPDATE: off
PGSCV_NO_TRACK_MODE: true
PGSCV_DISABLE_COLLECTORS: system,postgres/logs,postgres/storage
POSTGRES_DSN: postgresql://XXX:[email protected]:5432/postgres?sslmode=verify-full&sslrootcert=/psql-root.crt

Errors and Logs {"level":"warn","service":"pgscv","time":"2023-05-10T06:29:33Z","message":"failed to close database connection: tls: failed to send closeNotify alert (but connection was closed anyway): write tcp xx.x.x.xx:51086->xx.xx.xxx.xxx:5432: write: broken pipe; ignore"}

Environment:

• Used Container: Alpine Linux v3.13.11 lesovsky/pgscv:v0.8.0-beta.6
• pgSCV Version: pgscv v0.8.0-beta.6 3650072-HEAD
• PostgreSQL Version: 11.17
• PostgreSQL Azure DaaS