EnterpriseDB Postgres Enterprise Manager (PEM) provides functionality to send SNMP traps for integration into an upstream monitoring system.This how-to demonstrates a basic interface between PEM and SNMP, and assumes basic familiarity with SNMP. This document will cover three main topics:
How to generate the PEM Management Information Base (MIB)
How to configure PEM to send traps
How to configure individual SNMP alerts
Generate the PEM MIB
The query psql -U postgres -d pem -A -t -c "SELECT pem.generate_alert_mib();" > /path/to/mibs/PEM-ALERTING-MIB.mib provides the structure and varbinds for the traps that PEM will send. A copy of the MIB may need to be installed on the trap receiver host. The MIB needs to be regenerated after new custom probes or custom alerts are created, so that the new OIDs are included.