Grafana Postgres Connectivity

Hi Team ,

We are using Grafana 6.2 Version and One of the Application team is using Postgres 13.3 Version where as data is reporting to grafana and they have upgraded their postgres db to 16 version post that we are unable to see the data in grafana.

  1. We have lost all the historic data of that postgres db any idea why we lost?

  2. Application team have created new db with same 13.3 Version but we are unable to connect with the new datasource also any idea why we are unable to connect with new datasource?

I’m sorry to hear that you’re experiencing difficulties.

Grafana can provide valuable information about certain issues through its own debug logs. These logs can help troubleshoot and identify the root cause of problems (especially if they are related to anything that can be configured via Grafana config file).

To enable debug logging edit the configuration file grafana.ini:

[log]
# Either "console", "file", "syslog". Default is console and file
# Use space to separate multiple modes, e.g. "console file"
mode = console file

# Either "debug", "info", "warn", "error", "critical", default is "info"
level = debug

Then restart grafana for the setting to go into effect.

Replicate the problem and check Grafana logs. However, before posting the debug logs on the community forum, it is important to sanitize any private details such as passwords, tokens, IPs, names, … By including properly formatted debug logs (with sanitized information) and details about your installations (e.g. exact Grafana version, how it was installed, OS details, …), you greatly enhance the chances of receiving accurate assistance and solutions.