Grafana unable to connect Azure Postgresql Flexible server

[Prabir Kr Sarkar <prabir.kr.sarkar@xxxxxxxxx>]

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