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.

Please note that the Streaming Replication wizard and Package Deployment wizard are being deprecated. These two features will not be available in future releases of PEM.

This document uses Postgres to mean either the PostgreSQL or EDB Postgres Advanced Server database.

• The PEM Query Tool
  • The SQL Editor Panel
  • The Data Output Panel
    • Data Output Tab
    • Explain Tab
    • Graphical Tab
    • Analysis Tab
    • Statistics Tab
    • Messages Tab
    • Notifications Tab
  • Query History Panel
  • Connection Status
• The PEM Schema Diff Tool
  • The Schema Diff Object Comparison Panel
  • Schema Diff DDL Comparison Panel
• Package Deployment
  • Installing a New Package
    • Reviewing Scheduled Tasks
  • Upgrading an Installed Package
• Performance Monitoring and Management
  • Using Dashboards to View Performance Information
  • Managing Custom Dashboards
    • Creating a Custom Dashboard
    • Creating an Ops Dashboard
  • Using the Manage Charts tab
    • Creating a Custom Chart
    • Importing a Capacity Manager Template
  • Customizing Probes
    • Creating a Custom Probe
    • Deleting a Probe
    • Copying a Probe
  • Alerting
    • Using the Alerts Dashboard
    • Using the Manage Alerts Tab
    • Using PEM with Nagios
• Capacity Manager
  • Capacity Manager Templates
• Audit Manager
  • Setting the Advanced Server Instance Service ID
  • Setting the EDB Audit Configuration Probe
  • Configuring Audit Logging with the Audit Manager
  • Viewing the Log with the Audit Log Dashboard
• Log Manager
  • Reviewing the Server Log Analysis Dashboard
• Postgres Log Analysis Expert
  • Reviewing the Postgres Log Analysis Expert Report
• SQL Profiling and Analysis
  • Creating a New SQL Trace
    • Creating a Trace
    • Opening an Existing Trace
    • Filtering a Trace
    • Deleting a Trace
    • Viewing Scheduled Traces
  • Using the Index Advisor
• Tuning Wizard
• Postgres Expert - Best Practice Enforcement
  • Using the Postgres Expert Wizard
  • Reviewing Postgres Expert Recommendations
• Configuring Streaming Replication
  • Monitoring Streaming Replication and Failover Manager
    • Configuring High-Availability for PEM
• Reports
  • System Configuration Report
  • Core Usage Report
• Monitoring Failover Manager
  • Replacing a Master Node
• Monitoring an xDB Replication Cluster
• Performance Diagnostics
• Reference
  • PEM Server Configuration Parameters - Reference
  • Capacity Manager Metrics - Reference
  • PEM Probes – Reference
  • PEM Pre-defined Alert Templates – Reference
    • Templates applicable on Agent
    • Templates applicable on Server
    • Templates applicable on Database
    • Templates applicable on Schema
    • Templates applicable on Table
    • Global Templates
• Conclusion