Error when trying to add Postgresql as a data source

Grafana PostgreSQL
1

Hi,

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

I am giving the right password.
image

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?

2

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

3

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.

4

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?

5

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.

6

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