PEM Enterprise Features Guide¶
This guide will acquaint you with the tools and wizards that are built into the Postgres Enterprise Manager (PEM) web interface that make it easier for you to monitor and manage your system.
This guide is not a comprehensive resource; rather, it is meant to serve as an aid to help you evaluate the tool and bring you up to speed with the basics of how to use the product. For more detailed information about using PEM’s functionality, please see the online help made available by the PEM client.
This document uses Postgres to mean either the PostgreSQL or EDB
Postgres Advanced Server database or EDB Postgres Extended (formerly
known as 2ndQPostgres).
what’s_new pem_query_tool pem_schema_diff_tool pem_erd_tool performance_monitoring_and_management capacity_manager audit_manager log_manager sql_profiler tuning_wizard postgres_expert reports monitoring_BDR_node monitoring_failover_manager monitoring_xdb_replication_cluster performance_diagnostic reference conclusion
- The PEM Query tool
- The PEM Schema Diff tool
- The ERD tool
- Performance monitoring and management
- Using dashboards to view performance information
- Managing custom dashboards
- Using the Manage Charts tab
- Probes
- Alerting
- Notifications
- SMTP
- Creating an email group
- Deleting an Email Group
- Webhook
- Creating a webhook
- Defining webhook SSL configurations
- Deleting a webhook
- SNMP
- Example - Configure
SNMP V3traps withnet-snmptrap receiver - Using PEM with Nagios
- Enabling Nagios notification for an alert
- Configuring Nagios-related behavior of the PEM Server
- Creating the hosts.cfg and services.cfg file
- Modifying the Nagios configuration file
- Performance Diagnostic
- Capacity Manager
- Audit Manager
- Log Manager
- SQL profiling and analysis
- Tuning Wizard
- Postgres Expert - best practice enforcement
- Monitoring BDR nodes
- Prerequisites for monitoring Barman
- Configuring a Barman Server
- Viewing the Barman Server details on a PEM dashboard
- Monitoring Failover Manager
- Monitoring an xDB Replication cluster
- Reports
- Reference