Postgres Enterprise Manager - User Guide

Welcome to Postgres Enterprise Manager (PEM) User Guide. This guide describes all the functions and features that users will use in PEM. PEM consists of components that provide the management and analytical functionality for your EDB Postgres Advanced Server or PostgreSQL database. PEM is based on the Open Source pgAdmin 4 project. PEM is a comprehensive database design and management system. PEM is designed to meet the needs of both novice and experienced Postgres users alike, providing a powerful graphical interface that simplifies the creation, maintenance, and use of database objects.

• Accessing the web interface
  • The PEM menu bar
    • The File menu
    • The Object menu
    • The Management menu
    • The Dashboards menu
    • The Tools menu
    • The Help menu
  • Controlling and customizing charts, graphs and tables
• Monitoring performance
  • Probes
    • System probes
    • BDR probes
    • Customizing probes
    • PEM probes – reference
  • Alerts
    • Viewing the alerts via Global dashboard
    • Viewing the alerts via Alerts dashboard
    • Customizing the Alerts dashboard
    • Defining a new alert template
    • Exporting or importing alert templates
    • Modifying or deleting an alert template
    • Templates applicable on agent
    • Templates applicable on server
    • Templates applicable on database
    • Templates applicable on schema
    • Templates applicable on table
    • Global templates
    • Audit log alerting
    • Schedule an alert blackout
  • Notifications
    • SMTP
    • Webhook
    • SNMP
    • Using PEM with Nagios
  • Capacity Manager
    • Capacity Manager templates
    • Capacity Manager metrics - reference
  • Audit Manager
    • Setting the EDB Postgres 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
  • Charts
    • Creating a custom chart
    • Importing a Capacity Manager template
  • Dashboards
    • Dashboards overview
    • Dashboard configuration
    • Managing custom dashboards
  • Remote monitoring
• Monitoring Barman
  • Prerequisites for monitoring Barman
  • Configuring a Barman server
    • Using PEM web client
    • Configure
    • Editing
    • Using pemworker command line
  • Viewing the Barman server details on a PEM dashboard
• Managing BART
  • Prerequisites
  • Configuring a BART server
  • Associating the BART server with a database server
  • Viewing the BART server details on a PEM dashboard
  • Scheduling BART backups
  • Scheduling BART obsolete backups deletion
  • Restoring BART backups
• Monitoring BDR
• Monitoring Failover Manager
  • Replacing a primary node
  • Switchover EFM cluster
• Monitoring Replication Server
• Tuning performance
  • Tuning Wizard
  • Postgres Expert - best practice enforcement
    • Using the Postgres Expert wizard
    • Reviewing Postgres Expert recommendations
  • Performance Diagnostic
• Profiling workloads
  • SQL Profiler
    • Installing the SQL Profiler plugin
    • SQL profiling and analysis
    • Uninstalling SQL Profiler
  • Using the Index Advisor
• Viewing system reports
  • System Configuration Report
  • Core Usage report
• PEM command line interface
  • Example