from Gatherer #1] pq: SSL is not enabled on the server

[prashantnitt07]

getting error from sql_exporter agent

No metrics gathered, [from Gatherer #1] pq: SSL is not enabled on the server

[prashantnitt07]

I0802 17:54:36.378701 2655919 promhttp.go:39] Error gathering metrics: [from Gatherer #1] pq: SSL is not enabled on the server
I0802 17:56:11.561959 2655919 promhttp.go:39] Error gathering metrics: [from Gatherer #1] pq: SSL is not enabled on the server
I0802 17:59:24.927661 2655919 promhttp.go:39] Error gathering metrics: [from Gatherer #1] pq: SSL is not enabled on the server
^C

[burningalchemist]

Hi @prashantnitt07, not a bug of sql_exporter. The message comes from the underlying driver and states that the PostgreSQL server you're trying to connect to doesn't have SSL connection enabled.

You can add ?sslmode=disable parameter to your connection string, this should solve the issue. Let me know if you need any help. 👍

Reference link: https://stackoverflow.com/a/51642783

[prashantnitt07]

thanks , working fine after add in DSN

[prashantnitt07]

postgres://username:password@host:5432/database?sslmode=disable