"No dbs configured for monitoring" despite configuration in sources.yaml

[Mtou-K8ouf]

Hello,
Context:
I'm trying to use pgwatch with the Prometheus sink. I've configured my database gaston in the sources.yaml file,
but when I start pgwatch and prometheus, I get the following error:

SINK : prometheus address ::9187 No dbs configured for monitoring  check config sinks/prometheus.go :163

Configuration used:
version pgwatch 3.7.0

- name: gaston
  kind: postgres
  conn_str: "postgres://pgwatch:xxxx@xxxx:5517/gaston"
  is_superuser: false
  custom_metrics:
    - active_connections
    - cache_hit_ratio
    - cpu_load
    - db_size
  prometheus_mode: true
  group: default

What I've checked:

• The sources.yaml file is properly mounted and read
• Prometheus mode is enabled
• Metrics are valid
• Port 9187 is exposed

Questions:

• Is there an additional step required for pgwatch to recognize the database as "configured" for Prometheus?
• Does the sources.yaml file need to be explicitly referenced in another config?
• Does the Prometheus sink require special configuration in config.yaml?

Thanks in advance for your help

[pashagolub]

You forgot to specify intervals for metrics, e.g.

  custom_metrics:
    active_connections: 60
    cache_hit_ratio: 100
    cpu_load: 20
    db_size: 12000

[Mtou-K8ouf]

Thanks you for your help. The issue is resolved.