[OpenNMS/opennms] d5061a: Add PostgreSQL health metrics to the default JDBC ...

  Branch: refs/heads/dcy/moar-postgres-metrics
  Home:   https://github.com/OpenNMS/opennms
  Commit: d5061aa02b86c51710324b115c612931dcd86cb2
      https://github.com/OpenNMS/opennms/commit/d5061aa02b86c51710324b115c612931dcd86cb2
  Author: Dino <[email protected]>
  Date:   2026-08-25 (Tue, 25 Aug 2026)

  Changed paths:
    M core/schema/src/main/java/org/opennms/core/schema/Migrator.java
    M opennms-base-assembly/src/main/filtered/etc/jdbc-datacollection-config.xml
    A opennms-base-assembly/src/main/filtered/etc/snmp-graph.properties.d/postgresql-activity-graph.properties
    A opennms-base-assembly/src/main/filtered/etc/snmp-graph.properties.d/postgresql-dead-tuples-graph.properties
    A opennms-base-assembly/src/main/filtered/etc/snmp-graph.properties.d/postgresql-xid-graph.properties
    M opennms-base-assembly/src/main/filtered/etc/threshd-configuration.xml
    M opennms-base-assembly/src/main/filtered/etc/thresholds.xml

  Log Message:
  -----------
  Add PostgreSQL health metrics to the default JDBC collection

Collect dead tuples, backend states by pg_stat_activity state, xid
horizon ages (backend snapshots, replication slots, standby feedback,
prepared xacts), and autovacuum worker usage vs autovacuum_max_workers
via the OpenNMS-DB service, so the queries run against the opennms
database and datasource. Add matching graph definitions and a
"postgresql" threshold group covering xid horizon age, idle-in-
transaction backends, and autovacuum worker saturation.

The pg_stat_activity queries need the pg_monitor role, so the installer
now grants it to the OpenNMS user during database preparation, and a
pg_sa_masked canary datasource counts sessions hidden from the
monitoring role (nonzero means the grant is missing).



To unsubscribe from these emails, change your notification settings at https://github.com/OpenNMS/opennms/settings/notifications


_______________________________________________
Please read the OpenNMS Mailing List FAQ:
http://www.opennms.org/wiki/index.php?page=MailingListFaq
opennms-cvs mailing list

To *unsubscribe* or change your subscription options, see the bottom of this page:
https://lists.sourceforge.net/lists/listinfo/opennms-cvs