Postgres Enterprise Manager v9

Suggest edits

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.

Postgres compatibility

Supported versions of Postgres for PEM 9.x:

Monitored InstanceBackend Instance
EDB Postgres Advanced Server (EPAS)12, 13, 14, 15, 1612, 13, 14, 15, 16
PostgreSQL (PG)12, 13, 14, 15, 1612, 13, 14, 15, 16
EDB Postgres Extended Server (PGE)12, 13, 14, 15, 1613, 14, 15, 161
  1. sslutils isn't available for RHEL 7 on IBM Power, so this distribution can't use PGE as a backend.↩

Planning

Components and architecture

Deployment considerations

Installing and Upgrading

Installing the PEM server

Installing the PEM agent

Upgrading

Uninstalling

Troubleshooting

Administering

Changing the default port

Registering a Postgres server

Registering a PEM agent

Managing the PEM server

Managing Postgres servers

Managing PEM agents

Managing SSL certificates

Configuration settings

Agent issues

Using

Accessing the web interface

Connecting and disconnecting a database server

Monitoring performance

Monitoring Barman

Managing BART

Monitoring EDB Postgres Distributed

Monitoring Failover Manager

Monitoring Replication Server

Tuning performance

Profiling workloads

Viewing system reports

PEM command line interface

Developing

Using the Query tool

Using the Schema Diff tool

Using the ERD tool

Online Help

Accessing in-app help