Question about Grafana and PostgreSQL compatibility

Hi Everyone,

I’m running Grafana v9.5.21 and I’d like to use PostgreSQL 10.23 as the Grafana state database (instead of SQLite/MySQL/Postgres newer versions).

Is PostgreSQL 10.23 officially supported or known to work reliably with Grafana 9.5.21? Or should I plan to upgrade PostgreSQL to a newer version for long-term stability and support?

Thanks a lot for your help!

I would test that out using docker container with that version of grafana and postgres

1 Like

@yosiasz What should we test to ensure proper functionality? I can monitor Grafana logs, but that may not reveal hidden issues.

You would test out everything or most things in existing grafana that uses PostgreSQL 10.23 version within the another instance of Grafana 9.5.21 that uses newer version of PostgreSQL.

Another option if you do not want to go the docker route is:

on a local machine or virtual machine spin up a Grafana 9.5.21 that basically uses the out of the box sqlite db test_grafana and a PostgreSQL db test_pg with newest version.

backup current PostgreSQL 10.23 db of your Grafana 9.5.21

restore backup to test_pg

change ini of test_grafana to point to test_pg

restart test_grafana

1 Like