Error when trying to add Postgresql as a data source


I am trying to establish a connection between Grafana and my Postgresql data source plugin. But somehow, everytime it says

I am giving the right password.

I am using an open source version of grafana and postgres 14. Hosted in the same machine.

  • What Grafana version and what operating system are you using?

  • What are you trying to achieve?

  • How are you trying to achieve it?

  • What happened?

  • What did you expect to happen?

  • Can you copy/paste the configuration(s) that you are having problems with?

  • Did you receive any errors in the Grafana UI or in related logs? If so, please tell us exactly what they were.

  • Did you follow any online instructions? If so, what is the URL?

Hi @svenkatesan I’m having a similar issue, did you ever manage to solve this?

No. I couldn’t resolve this. I went ahead with using a CSV file. But pls do let me know, if you have a breakthrough.

Is postgres installed on same host as grafana?

What operating system is the host?

Why are you trying to connect to postgres database which is a system database?

Does the user postgres have full access to the postgres database?

Hi yosiasz, Windows is the OS.

Postgres is the sql db to store the data and to be used as a datasource. And the user postgres has full admin access to the db.

Found the issue with mine. Basically wrong user cred copied over.

My setup was minikube with zalando operator setting up postgres and grafana helm chart.

1 Like