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 to Postgres Enterprise Manager
  • Postgres compatibility
  • Postgres Enterprise Manager release notes
    • Postgres Enterprise Manager 10.2.0 release notes
    • Postgres Enterprise Manager 10.1.2 release notes
    • Postgres Enterprise Manager 10.1.1 release notes
    • Postgres Enterprise Manager 10.1.0 release notes
    • Postgres Enterprise Manager 10.0.0 release notes
  • Platform compatibility
  • Hardware requirements for installing the PEM server on Linux
• Planning your deployment
  • Understanding Postgres Enterprise Manager components and architecture
    • PEM architecture
  • Deployment considerations
    • Connection pooling using PgBouncer
    • Authentication options
    • Securing your deployment
    • Web server installation options
    • High Availability Patterns for PEM Deployment
• Installing and Upgrading Postgres Enterprise Manager
  • 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 the PEM web server
    • Moving the PEM server
  • Uninstalling
    • Uninstalling Postgres Enterprise Manager components on Linux
    • Uninstalling Postgres Enterprise Manager components on Windows
  • Troubleshooting
    • Known installation and configuration issues
    • Reconfiguring the PEM server
    • PEM web application not loading
    • Error connecting to PostgreSQL server
    • PEM web server connectivity check
• Administering Postgres Enterprise Manager
  • 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 web server on Linux
    • Controlling the web server on Windows
    • 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 Postgres Enterprise Manager
  • Accessing the web interface
    • 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
    • Performance Diagnostic
  • Profiling workloads
    • Installing the SQL Profiler extension
    • Using SQL Profiler
  • Viewing system reports
    • Alert History report
    • System Configuration report
    • Core Usage report
  • PEM command line interface
    • Example
  • EDB Postgres Enterprise Manager REST APIs v1.0.0
    • Token
• Developing Postgres Enterprise Manager
  • Using the Query tool
    • The Query tool toolbar
    • The SQL editor panel
    • The Data Output panel
    • Query History panel
    • Connection status
    • Macros
  • 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
  • PL debugger
    • In-context debugging
    • Direct debugging
    • Using the debugger
• Using Postgres Enterprise Manager
  • Accessing the web interface
    • 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
    • Performance Diagnostic
  • Profiling workloads
    • Installing the SQL Profiler extension
    • Using SQL Profiler
  • Viewing system reports
    • Alert History report
    • System Configuration report
    • Core Usage report
  • PEM command line interface
    • Example
  • EDB Postgres Enterprise Manager REST APIs v1.0.0
    • Token