Connection refused when connecting to the Azure postgres database

[rami213671]

Hi repo Admin,

Running listmonk as docker microservice on AKS Kubernetes cluster and I'm getting the following error in the logs of the container of listmonk:

listmonk-588bd47569-kcgzc:listmonk 2024/07/24 14:29:20 init.go:293: error connecting to DB: dial tcp 10.1.2.3:5432: connect: connection refused

Even though I'm able to connect to the database with the same credential from the cluster either via pgadmin tool or using postgress cli command line.

Logs from the database server side:

2024-07-11 18:43:21 UTC-669027c9.5405-LOG: connection received: host=10.25.93.27 port=41820 2024-07-11 18:43:21 UTC-669027c9.5405-LOG: connection authenticated: identity=\"psqldbadmin\" method=md5 (/datadrive/pg/data/pg_hba.conf:26) 2024-07-11 18:43:21 UTC-669027c9.5405-LOG: connection authorized: user=psqldbadmin database=listmonk-db SSL enabled (protocol=TLSv1.3, cipher=TLS_AES_256_GCM_SHA384, bits=256) 2024-07-11 18:43:21 UTC-669027c9.5405-LOG: could not receive data from client: Connection reset by peer 2024-07-11 18:43:21 UTC-669027c9.5405-LOG: disconnection: session time: 0:00:00.080 user=psqldbadmin database=listmonk-db host=10.25.93.27 port=41820 2024-07-11 18:43:24 UTC-669027b8.53e0-LOG: disconnection: session time: 0:00:20.017 user=azuresu database=azure_maintenance host=169.254.128.1 port=48104

Can you help me resolve this issue?

[MaximilianKohler]

Have you looked through the other "Connection refused" issues?

[github-actions[bot]]

This issue has been marked 'stale' after 90 days of inactivity. If there is no further activity, it will be closed in 7 days.