Grafana unable to connect Azure Postgresql Flexible server

From: Prabir Kr Sarkar <prabir(dot)kr(dot)sarkar(at)gmail(dot)com>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Grafana unable to connect Azure Postgresql Flexible server
Date: 2021-09-07 08:13:45
Message-ID: CADjSiz55xiWONznOoQXFe-YDufYhnGWN2Midx0FR1bCYvf3Ftg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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*

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Julien Rouhaud 2021-09-07 08:21:14 Re: Grafana unable to connect Azure Postgresql Flexible server
Previous Message Kyotaro Horiguchi 2021-09-07 06:24:21 Re: Estimating HugePages Requirements?