Postgres Enterprise Manager™ monitors a system for conditions that require user attention. An alert definition contains a system-defined or user-defined set of conditions that PEM compares to the system statistics; if the statistics deviate from the boundaries specified for that statistic, the alert triggers, displaying a High (red), Low (yellow) or Medium (orange) severity warning in the left-most column of the Alerts Status table on the Global Overview dashboard, and optionally sends a notification via email to Email Groups or SNMP trap/notification receivers.
PEM includes pre-defined alerts, as well as an interface that allows you to create customized alerts. The pre-defined alerts will call your attention to a server or agent that is out of service:
Using the Alerts Dashboard¶
Use the Dashboards menu (at the top of the Global Overview dashboard) to access the Alerts Dashboard. The Alerts Dashboard displays a summary of the active alerts and the status of each alert:
The Alerts Overview section of the Alerts Dashboard displays a graphic representation of the active alerts, as well as a count of the current High, Low and Medium alerts. The vertical bar on the left of the graph provides the count of the alerts displayed in each column. Hover over a bar to display the alert count for the selected alert severity in the upper-right hand corner of the Alerts Status graph.
The Alert Details table provides a list of the alerts that are currently triggered. The entries are prioritized from high-severity to lower-severity; each entry includes information that will allow you to identify the alert and recognize the condition that triggered the alert. Click the name of an alert to open a popup that provides detailed information about the alert definition.
The Alert Errors table displays configuration-related errors (eg. accidentally disabling a required probe, or improperly configuring an alert parameter). You can use the information provided in the Error Message column to identify and resolve the conflict that is causing the error; for additional assistance, contact EnterpriseDB Support.
Use the Refresh icon to update the content of the Alerts Dashboard.
Creating and Copying Alerts¶
PEM’s Manage Alerts tab allows you to define custom alerts or modify existing alerts. To open the Manage Alerts tab, select Manage Alerts… from the Management menu. The Manage Alerts tab provides an easy way to review the alerts that are currently defined for the object that is highlighted in the PEM client tree control; simply select an object to see the alerts that are defined for that object.
The Manage Alerts tab also provides Quick Links that provide quick access to dialogs that allow you to:
You can configure an alert to notify Nagios network-alerting software when that alert is triggered. For more information, see Using PEM with Nagios.
To create a new alert, click the add icon in the upper-right corner of the Alerts table.
SNMP MIB Generation¶
PEM allows alerts to be sent as SNMP traps or notifications to receivers such as network monitoring tools. To enable such tools to understand these notifications, a MIB file may be generated that describes the different alerts and accompanying information that PEM may send. The pem.generate_alert_mib() SQL function in the PEM database may be used to generate the MIB file from the alert templates defined in the database. For example:
psql.exe -U postgres -d pem -A -t -c "SELECT pem.generate_alert_mib();" > PEM-ALERTING-MIB
- Creating and Managing Alerts
- Email Groups
- Copy Alerts
- Alert Templates
- Custom Alert Templates
- Using PEM with Nagios