Grafana unable to connect Azure Postgresql Flexible server - Mailing list pgsql-admin

From Prabir Kr Sarkar
Subject Grafana unable to connect Azure Postgresql Flexible server
Date
Msg-id CADjSiz55xiWONznOoQXFe-YDufYhnGWN2Midx0FR1bCYvf3Ftg@mail.gmail.com
Whole thread Raw
Responses Re: Grafana unable to connect Azure Postgresql Flexible server
List pgsql-admin
Hi Gurus,
               I am new to Postgresql. Have the following implementation:

Grafana (7.5.1) deployed as Pod on AKS (Azure Kubernetes service).
Using grafana.ini it points to a Azure Postgresql Flexible server (13.3) within the same Vnet.

The grafana pod fails to start with the following error:

t=2021-09-07T06:40:00+0000 lvl=info msg="Connecting to DB" logger=sqlstore dbtype=postgres
t=2021-09-07T06:40:00+0000 lvl=info msg="Starting DB migrations" logger=migrator
service init failed: failed to check table existence: pq: no pg_hba.conf entry for host "10.240.1.45", user "grafana", database "grafana", SSL off

Note: - We can however, connect to the postgresql flexible server from a pod (with psql) in the same AKS.

Thanks and Regards
Prabir Sarkar

pgsql-admin by date:

Previous
From: Ian Dauncey
Date:
Subject: RE: vacuumlo
Next
From: Julien Rouhaud
Date:
Subject: Re: Grafana unable to connect Azure Postgresql Flexible server