How to setup Postgresql as a replacement to default sqlite3 in Grafana

Grafana Configuration
1

Need to setup Grafana with Dashboard metadata on Postgresql.
Note:- The telemetry data comes from InfluxDB.
As of now we have

  1. Updated the defaults.ini file to replace sqlite with postgres and created Grafana Docker image from it.
  2. Created a AKS Kubernetes deployment with GF_DATABASE_URL to point to out Postgresql running as PaaS on Azure.
  3. Manually created Grafana database in postgres.

But no grafana metadata (tables etc) are available in the postgres grafana database. And grafana UI (on Azure public IP) is not displaying anything.

Any help is appreciated.

Regards
Prabir

2

Hi @prabirkrsarkar

In asnwer to the general question, “How to setup Postgresql as a replacement to default sqlite3 in Grafana”: I would check out this detailed blog post about migrating.

However, what you are discussing is something more. Using postgres, building your own docker image, and then deploying it to Azure Kubernetes.

I wouldn’t try deploying until I had this working locally