Get Postgres Tips and Tricks
Subscribe to get advanced Postgres how-tos.
Postgres Enterprise Manager™¶
Welcome to Postgres Enterprise Manager™ (PEM). Postgres Enterprise Manager™ (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 IV project.
pgAdmin is the leading Open Source management tool for Postgres, the world’s most advanced Open Source database. pgAdmin IV is a comprehensive database design and management system. pgAdmin 4 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.
Contents:
- PEM Getting Started
- Managing a PEM Agent
- The PEM Client
- Enterprise Management Features
- Dashboards
- Accessing Dashboards
- Creating custom charts and dashboards
- Available Dashboards
- The Alerts Dashboard
- The Audit Log Analysis Dashboard
- The Database Analysis Dashboard
- The Global Overview Dashboard
- The I/O Analysis Dashboard
- The Memory Analysis Dashboard
- The Objects Activity Analysis Dashboard
- The Operating System Analysis Dashboard
- The Probe Log Analysis Dashboard
- The Server Analysis Dashboard
- The Server Log Analysis Dashboard
- The Session Activity Analysis Dashboard
- The Session Waits Analysis Dashboard
- The Storage Analysis Dashboard
- The System Wait Analysis Dashboard
- The Streaming Replication Analysis Dashboard
- Server Configuration
- Log Manager
- Audit Manager
- Postgres Log Analysis Expert
- Tuning Wizard
- Postgres Expert
- Capacity Manager
- Alerting
- Using the Manage Charts Tab
- The PEM Manage Dashboards Tab
- The Manage Probes Tab
- Scheduled System Jobs
- Scheduled Task Tab
- Creating a PEM Scheduled Job
- Sending email notifications for a job
- Task Viewer
- Monitoring a Failover Manager Cluster
- Performance Diagnostic
- Reports
- Dashboards
- Management Basics
- Grant Wizard
- Add named restore point Dialog
- Import/Export data Dialog
- Maintain a database object
- Backup Dialog
- Backup Globals Dialog
- Backup Server Dialog
- Restore Dialog
- Managing Cluster Level Objects
- Managing Database Objects
- Cast Dialog
- Collation Dialog
- Domain Dialog
- Domain Constraints Dialog
- Event Trigger Dialog
- Extension Dialog
- Foreign Data Wrapper Dialog
- Foreign Server Dialog
- Foreign Table Dialog
- FTS Configuration dialog
- FTS Dictionary Dialog
- FTS Parser Dialog
- FTS Template Dialog
- Function Dialog
- Language Dialog
- Materialized View Dialog
- Package Dialog
- Procedure Dialog
- Schema Dialog
- Sequence Dialog
- Synonym Dialog
- Trigger function Dialog
- Type Dialog
- User Mapping Dialog
- View Dialog
- Creating or Modifying a Table
- Ark Management Features
- Registering an Ark Console
- Managing an Ark Console
- Ark Console Installation Options
- Creating an Ark Server Image
- Creating a Database Engine
- Modifying a Database Engine
- Managing a Database Engine
- Creating a RHEL Subscription
- Managing a RHEL Subscription
- Creating an Ark User Template
- Managing a Template
- Adding an Ark User
- Creating an Ark Cluster
- Modifying an Ark Cluster
- Managing an Ark Cluster
- Managing a BART Server
- SQL Profiler
- Developer Tools
- Configuring pgBouncer for use with PEM Agents
- pgAgent
- Appendices
- Release Notes
Help buttons in the lower-left corner of each dialog will open the online help for the dialog. You can also access help by navigating through the Help menu, and selecting the name of the resource that you wish to open.