Postgres Pro Enterprise Manager
100% web-based
all functionality available in the browser, no additional software required
Single window
for monitoring, diagnostics, and management of multiple databases
0 SQL commands
required to perform routine operations
24/7
continuous real-time monitoring
Business Benefits
Reduced DBA Workload
Automation of routine tasks, metric visualization, query plan insights, and integration with pgpro_pwr and pg_probackup accelerate workflows and simplify performance analysis.
Compatibility and Fast Setup
PPEM works with any Postgres Pro edition. No need to deploy third-party tools — everything is built into a single solution with no extra cost or risk.
Centralized Management
A unified interface for monitoring, diagnostics, and configuration of multiple Postgres Pro instances within your infrastructure.
Simplicity and Transparency
Clear structure, role-based access control, built-in action history, and a task console ensure convenient and secure database operations.
Improved Security and Control
Flexible role assignment helps limit access to sensitive data and prevents accidental mistakes — everything stays under control without complex configuration.
Faster Onboarding
An intuitive interface, visualized metrics, and detailed status and history information significantly lower the learning curve for database administration.
Core Functional Modules
Dashboard
- Unified PPEM overview panel
- Displays key information about all databases connected to PPEM
Instances
- Monitoring and management of database instances: performance metric charts, session information, wait events, running SQL queries, and editable instance parameters
- Instance list, overview of all instances, basic actions: stop, start, backup, configuration
- Key performance characteristics
- A full set of metrics with customizable widgets and zoomable chart segments
- A database session list with selectable columns, field-based sorting, and filtering by session state
- Statistics on running SQL queries with database-level filtering and field-based sorting
- Query plan details and execution progress
- Management of authentication parameters
pgpro_pwr
- Diagnostic workload profiler: collects and stores performance history, generates diagnostic reports, provides period-based analytics and comparisons
- Configuration of target servers for pgpro_pwr
- Performance statistics snapshots
- Visualized metrics for any time period
- Period selection for generating diagnostic reports
- Sample diagnostic report
Tablespaces
- Management interface for tablespaces, including creation, editing, and deletion
- View and manage all tablespaces, create/edit/delete operations
Databases
- Information about databases, storage characteristics, and schema objects. Supports maintenance routines such as vacuum, reindex, and analyze
- Database list with key properties: size, number of tables and indexes, bloat level, wraparound warnings
- Launch the familiar psql utility directly from PPEM
- List of tables and indexes with summary details
- Database creation form
Backup & Restore
- Management of backup and restore tasks with configurable backup storage
- A list of backups with their status and key details. You can view detailed execution logs or open the restore form for any selected backup
- The “Backup Storage” tab defines where backups are stored, supporting both local locations and cloud storage via the S3 protocol
- A form for creating a backup task — it can be executed immediately or scheduled for later
Event Log
- Graphical interface for the instance event log with flexible search and filtering
- An instance event log with selectable time ranges, filtering options, and full-text search
PPEM Settings
- User and permission management, as well as configuration of metric and log retention
- Management of PPEM users and their privileges through a role-based access model
- Configuration of cleanup rules for the service repository
Key Capabilities
- Monitoring and Diagnostics A complete view of database health: charts for key metrics, query activity analysis, and execution plan visualization. Identify bottlenecks and react before issues appear.
- Workload Reporting An interface to the pgpro_pwr module: automatic snapshot creation, report generation, and visual analytics. Understand which operations consume the most resources.
- Instance and Configuration Management Create, start, stop, and configure Postgres Pro instances from a single interface. Simplifies operations and reduces DBA workload.
- Task Scheduling and Automation Set maintenance schedules for vacuum, analyze, reindex, and other operations. All processes are transparent — you see status, duration, and execution results.
- Hands-Free Backups Integration with pg_probackup enables scheduled backups and point-and-click data restoration.
- Flexible Access Control and Change History Role-based access and built-in authentication allow precise permission management. Every action from tasks to configuration changes is logged, so you always know who did what.
- Automatic Instance Discovery (Autodiscovery Mode) PPEM can detect new database instances on the network automatically. Reduce onboarding time for new databases and simplify scaling.
- Custom Metrics and Widgets Add your own performance indicators. Adapt monitoring to your business logic or infrastructure specifics.
FAQ
Does PPEM support clusters, or only single instances?
PPEM works with both standalone instances and high-availability Postgres Pro clusters managed by BiHA. You can manage replicas, track their status, and switch between nodes directly from the interface. For Patroni-managed clusters, PPEM provides automatic node discovery and visual cluster representation within the interface.
What resources are required to install PPEM?
PPEM requires a server (virtual or physical) running a Linux-based OS and a Postgres Pro instance used as the service repository. The platform deploys quickly and does not require any additional software on user workstations — everything runs directly in the browser.
Are there any limits on the number of managed instances?
PPEM scales to meet the needs of large organizations. Performance depends on the resources of the server it runs on, and there are no declared internal limits on the number of managed instances.
How is PPEM updated, and how often are new versions released?
New PPEM versions are released quarterly, following the product’s standard release cycle. Updates are installed through the package manager or repository in the usual way.
Can PPEM be used with PostgreSQL, not just Postgres Pro?
Yes, PPEM is compatible with vanilla PostgreSQL. However, its full capabilities (such as pgpro_pwr and pg_probackup) are unlocked when used with Postgres Pro, since these components are part of the Postgres Pro ecosystem.
Can PPEM be deployed in an isolated environment without internet access?
Yes. PPEM is designed for operation within closed corporate environments and does not require access to external services.
Can PPEM be integrated with LDAP for centralized authentication?
Yes. PPEM supports integration with external authentication systems, including LDAP, enabling centralized access management in corporate environments.