Default PGSQL dashboard shows no data

[anadyrov]

Hi! After deploying Pigsty following the official instructions (main branch, using the pgsql + infra roles), we noticed that the PGSQL Database dashboard does not work "out of the box":
the variables (ins, cls, seq, ip, node) in Grafana appear empty, and most of the panels show "no data".

Prometheus collects metrics from postgres_exporter at: 9188, data is available.
In the files /etc/prometheus/targets/pgrds/*.yml we registered the labels cls, ins, node, seq, ip — Prometheus saw them (we checked them via API).
Metrics like pg_up, pg_stat_activity_sessions, pg_db_age, pg_size_bytes are also available with the labels ins, cls, etc.
All Prometheus targets are in the UP state, except for those where PostgreSQL was temporarily unavailable.
Trying to import the dashboard again did not help.

grep version /root/pigsty/pigsty.yml
version: v3.3.0 # pigsty version string
pg_version: 17 # default postgres version

[Vonng]

Seems your are using Pigsty to montoring existing postgres instances.

The export we use is pg_exporter (default port 9630)

I wonder your exporter is the postgres_exporter which is a different one.

[anadyrov]

We set up pg_exporter, and it helped us with monitoring our PostgreSQL instances.
Thank you for the information!