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.
- Postgres compatibility
- Postgres Enterprise Manager release notes
- Postgres Enterprise Manager 10.5.0 release notes
- Postgres Enterprise Manager 10.4.2 release notes
- Postgres Enterprise Manager 10.4.1 release notes
- Postgres Enterprise Manager 10.4.0 release notes
- Postgres Enterprise Manager 10.3.1 release notes
- Postgres Enterprise Manager 10.3.0 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
- Understanding Postgres Enterprise Manager components and architecture
- Deployment considerations
- 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
- Dependencies of the PEM Server and Agent on Linux
- Installing Postgres Enterprise Manager server on Linux x86 (amd64)
- Installing Postgres Enterprise Manager server on Linux AArch64 (ARM64)
- Installing Postgres Enterprise Manager server on Linux IBM Power (ppc64le)
- Installing Postgres Enterprise Manager server on Windows
- Creating an EDB repository on an isolated network
- Configuring the PEM server on Linux
- Installing Postgres Enterprise Manager in HA Patterns
- Installing Postgres Enterprise Manager agent
- Configuring user authentication in PEM
- Configuring the PEM server to use two-factor authentication
- Configuring the PEM server to use Kerberos authentication
- Configuring the PEM server to use Windows Active Directory domain services for Kerberos authentication (SSPI)
- 1. Install Active Directory, the PEM server, and the PEM backend database server
- 2. Create users in Active Directory to map with service principals
- 3. Extract key tables from Active Directory
- 4. Configure the PEM backend database server
- 5. Obtain and view the initial ticket
- 6. Configure the PEM server
- Connection pooling using PgBouncer
- Upgrade and migration
- Upgrading a PEM installation
- PEM upgrade best practices and remediation
- 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
- Splitting an existing PEM server
- Uninstalling
- 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
- SQL Error - column “ssl” of relation “server” does not exist
- SSL Error - Incomplete sslutils upgrade
- Nginx SSL_read() failure errors
- Installing Postgres Enterprise Manager server
- ADMINISTERING
- Changing the default port
- Registering a PEM agent
- Registering a Postgres server
- 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
- Managing a PEM agent
- Scheduled system jobs
- Managing SSL certificates
- Managing configuration settings
- Troubleshooting agent issues
- USING
- Accessing the web interface
- Connecting and disconnecting a database server
- Monitoring performance
- Monitoring Barman
- Monitoring EDB Postgres Distributed
- Cluster topology
- Monitoring Failover Manager
- Monitoring Replication Server
- Monitoring event history
- Why is it important?
- Core benefits
- Supported functionalities
- Typical operational scenarios
- Event entry reference
- 1. Profile assignment
- 2. Profile clone
- 3. Profile export
- 4. Profile import (new name)
- 5. Profile import (overwrite → draft)
- 6. Alert blackout enabled (checkbox)
- 7. Alert blackout disabled (checkbox)
- 8. Scheduled blackout created (dialog)
- 9. Scheduled blackout deleted (dialog)
- 10. Manual blackout expired
- 11. Scheduled blackout completed
- 12. Auto blackout enabled
- 13. Auto blackout disabled
- 14. HA switchover
- How to glance at recent activity
- Reading the details field
- Considerations
- Tuning performance
- Profiling workloads
- Reports
- PEM command line interface
- EDB Postgres Enterprise Manager REST APIs v1.0.0
- DEVELOPING