postgres_exporter integration ignores include/exclude databases config

snorfalorpagus commented 1 year ago

I'm trying to use Grafana Agent to export metrics about a single database on a PostgreSQL server. However the include_databases option appears to be ignored: all of the databases on the server are reported (e.g. postgres, template0, ...). Similarly adding these to exclude_databases has no effect.

integrations:
  postgres_exporter:
    enabled: true
    disable_settings_metrics: true
    data_source_names:
      - postgresql://[redacted]/mydataabse
    autodiscover_databases: true
    include_databases:
      - mydatabase

I'm not sure if this is a misconfiguration problem or a bug.

Grafana Agent version information:

./agent-linux-amd64 --version
agent, version v0.29.0 (branch: HEAD, revision: 4e92c569)
  build user:       root@ccd16eb532f7
  build date:       2022-11-08T15:16:38Z
  go version:       go1.19.3
  platform:         linux/amd64

Running against PostgreSQL 13.7, hosted on AWS RDS.

marctc commented 1 year ago

Hey @snorfalorpagus, thanks for reporting. Seems to be an upstream problem (postgres_exporter). See https://github.com/prometheus-community/postgres_exporter/issues/568

rfratto commented 5 months ago

Hi there :wave:

On April 9, 2024, Grafana Labs announced Grafana Alloy, the spirital successor to Grafana Agent and the final form of Grafana Agent flow mode. As a result, Grafana Agent has been deprecated and will only be receiving bug and security fixes until its end-of-life around November 1, 2025.

To make things easier for maintainers, we're in the process of migrating all issues tagged variant/flow to the Grafana Alloy repository to have a single home for tracking issues. This issue is likely something we'll want to address in both Grafana Alloy and Grafana Agent, so just because it's being moved doesn't mean we won't address the issue in Grafana Agent :)

grafana / alloy

postgres_exporter integration ignores include/exclude databases config #501