Cannot Connect Postgresql database to Grafana Dashboard using Postgres Exporter

[paldapd]

Hello, I'm creating a dashboard database using Postgres Exporter, Prometheus, and Grafana. But it seems the database is not connected to the grafana dashboard because there is no data and the database not appear on dashboard. Then i check Prometheus, there is no query for pg_stat? The only queries available are pg_exporter_last_scrape_duration_seconds, pg_up, pg_exporter_last_scrape_error, pg_exporter_scrapes_total. So basically, I'm missing some metrics from the PostgreSQL exporter. Can anyone help me on how to resolve this? Thank you.

[vanallam]

I faced the same problem and I solved it after giving postgres_exporter the correct configs, so look at postgres_exporter logs it will help you