Postgres Enterprise Manager

Welcome to Postgres Enterprise Manager (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.

• Introduction
  • Postgres compatibility
  • Release notes
    • Postgres Enterprise Manager 9.8.0 release notes
    • Postgres Enterprise Manager 9.7.0 release notes
    • Postgres Enterprise Manager 9.6.0 release notes
    • Postgres Enterprise Manager 9.5.1 release notes
    • Postgres Enterprise Manager 9.5.0 release notes
    • Postgres Enterprise Manager 9.4.1 release notes
    • Postgres Enterprise Manager 9.4.0 release notes
    • Postgres Enterprise Manager 9.3.1 release notes
    • Postgres Enterprise Manager 9.3.0 release notes
    • Postgres Enterprise Manager 9.2.2 release notes
    • Postgres Enterprise Manager 9.2.1 release notes
    • Postgres Enterprise Manager 9.2.0 release notes
    • Postgres Enterprise Manager 9.1.1 release notes
    • Postgres Enterprise Manager 9.1.0 release notes
    • Postgres Enterprise Manager 9.0.0 release notes
  • Platform compatibility
  • Hardware requirements for installing the PEM server on Linux
• Planning
  • Understanding Postgres Enterprise Manager components and architecture
    • PEM architecture
  • Deployment considerations
    • Using Failover Manager for high availability
    • Connection pooling using PgBouncer
    • Authentication options
    • Securing your deployment
    • Web server installation options
    • How PEM licensing works
• Installing and Upgrading
  • Installing Postgres Enterprise Manager server
    • Linux x86-64 (amd64)
    • Linux Installing Postgres Enterprise Manager server on Linux IBM Power (ppc64le)
    • Linux Installing Postgres Enterprise Manager server on Linux AArch64 (ARM64)
    • Windows
  • Installing Postgres Enterprise Manager agent
    • Linux x86-64 (amd64)
    • Linux Installing Postgres Enterprise Manager server on Linux IBM Power (ppc64le)
    • Linux Installing Postgres Enterprise Manager server on Linux AArch64 (ARM64)
    • Windows
  • Upgrade and migration
    • Upgrading a PEM installation
    • Upgrading the PEM backend Postgres database
    • Adding entries for PEM Agens and admins to connect to PEM server
    • Adding entries (localhost) for PEM Agens and admins to connect to PEM server
    • Upgrading SQL Profiler
    • Upgrading Apache HTTPD server
    • Moving the PEM server
  • Uninstalling
    • Uninstalling Postgres Enterprise Manager components on Linux
    • Uninstalling Postgres Enterprise Manager components on Windows
  • Troubleshooting
    • Server installation errors
    • Reconfiguring the PEM server
    • PEM web client not loading
    • Error connecting to PostgreSQL server
    • PEM web server status check
• Administering
  • Changing the default port
    • For RHEL
    • For Debian and Ubuntu
  • Registering a Postgres server
    • What does registering a Postgres server do?
    • Using the pemworker utility to register a server
    • Registering a server with automatic server discovery
    • Manually registering a database server
    • Verifying the connection and binding
  • Registering a PEM agent
    • How to register PEM agents
    • Registering a PEM agent using the pemworker utility
    • Unregistering a PEM agent
    • Advanced usage
  • Managing a PEM server
    • Starting and stopping the PEM server and agents
    • Controlling the PEM server or PEM agent on Linux
    • Controlling the PEM server or PEM agent on Windows
    • Controlling the HTTPD server
    • Managing PEM authentication
    • Editing the PEM server configuration
    • Managing security
    • Server configuration
    • Server configuration parameters - reference
  • Managing Postgres servers
    • Starting and stopping monitored database servers
    • Modifying the pg_hba.conf file
    • Creating and maintaining databases and objects
    • Template Linux service script
  • Managing a PEM agent
    • Managing job notifications
    • Managing scheduled jobs
    • Modifying agent configuration
    • Reviewing or modifying agent properties
    • Setting agent privileges
  • Managing SSL certificates
    • Web-server certificates
    • PEM backend database server and agent connection certificates
    • Generate a common agent certificate and key pair
    • Use certificates and keys signed by trusted CA
    • Testing certificates
  • Managing configuration settings
  • Troubleshooting agent issues
    • Restoring a deleted PEM agent
    • Updating configuration file path (agent status displaying as unknown)
    • Using the command line to delete a PEM agent with down or unknown status
• Using
  • Accessing the web interface
    • Accessing in-app help for UI details
    • PEM client object browser
    • PEM tabbed browser window
    • Using chart, graph, and table controls
    • Browser toolbar
    • PEM menu bar
    • Controlling and customizing charts, graphs, and tables
  • Connecting and disconnecting a database server
    • Disconnecting from a server
  • Monitoring performance
    • Probes
    • Alerts
    • Notifications
    • Capacity Manager
    • Audit Manager
    • Log Manager
    • Charts
    • Dashboards
    • Remote monitoring
  • Monitoring Barman
    • Prerequisites for monitoring Barman
    • Configuring a Barman server
    • Viewing the Barman server details on a PEM dashboard
  • Monitoring EDB Postgres Distributed
  • Monitoring Failover Manager
    • Replacing a primary node
    • Switchover EFM cluster
  • Monitoring Replication Server
  • Monitoring event history
  • Tuning performance
    • Tuning Wizard
    • Postgres Expert
    • Performance Diagnostic
  • Profiling workloads
    • Installing the SQL Profiler extension
    • Using SQL Profiler
    • Using the Index Advisor
  • Viewing system reports
    • Alert History report
    • System Configuration report
    • Core Usage report
  • PEM command line interface
    • Example
  • PEM Rest API
• Developing
  • Using the Query tool
    • The Query tool toolbar
    • The SQL editor panel
    • The Data Output panel
    • Query History panel
    • Connection status
    • Macros
    • Accessing in-app help for UI details
  • Using the Schema Diff tool
    • Schema Diff Object Comparison panel
    • Schema Diff DDL Comparison panel
  • Using the ERD tool
    • Toolbar
    • File options
    • Export options
    • Editing options
    • Table relationship options
    • Utility Options
    • Zoom options
    • Table dialog
    • Table node
    • One-to-many link dialog box
    • Many-to-many link dialog box
    • Table link
    • Table notes