EnterpriseDBRegister for Free
  • Download Free Quick Tutorials on Enterprise Modules
  • Stay informed of the latest software updates
  • Learn from community leaders
  • Interact in product forums
  • Download free white papers
  • Watch free webcasts
  • Hear about PostgreSQL news
Register For Free

 

 
 

Postgres Enterprise Manager™

4.0 is now available with customizable dashboards and replication alerts!

Postgres Enterprise Manager is the only solution available today that allows you to intelligently manage, monitor, and tune large numbers of Postgres database servers enterprise-wide from an integrated graphical console.

With Postgres Enterprise Manager 4.0’s addition of customizable dashboards, a tuning wizard, replication alerts, and an update monitor, no other tool comes close to providing so many productivity features and ease of use in a professional enterprise grade monitoring and management tool for Postgres.  Download Postgres Enterprise Manager now.

Web-based client that allows you access to your monitoring data anytime - from anywhere!
Log Manager that configures logging across multiple databases at once and displays a consolidated view of all logs.
SSH tunneling for easier access outside the firewall.
Ability to use Postgres Plus Advanced Server as the backend database for the central Enteprise Manager server.
Multiple monitoring improvements.

Download Postgres Enterprise Manager

  Download Data Sheet |   Installation Guide

How To Buy EDB Tools

EDB Tools for Performance, Scalability, High Availability, and Management are included in the purchase of a Standard Edition or Enterprise Edition database subscription.

Compare and buy here


Feature Highlights:

 
 

Index Advisor

Recommends and/or deploys new table indexes based on specific troublesome queries.

Customizable Dashboards

Users can create specific views reflecting mission critical metrics for their installation.

Tuning Wizard

Configures machine utilization and application workload settings for each database.


Enterprise Design

Distributed architecture for flexible and efficient 'management en masse' of large installations.

View large video

Performance Dashboards

At-a-glance views for I/O, storage, memory, user and session activity, and wait statistics.

SQL Profiler

Efficient troubleshooting and optimizing of slow SQL.

View large video


Postgres Expert

Helps enforce best practices from man-years of Postgres expertise.

Capacity Manager

Provides trend analysis for storage and hardware plans.

View large video

Audit Manager

GUI management of fine grained auditing features in Postgres Plus Advanced Server.


Log Manager

Configure multiple databases at once and view consolidated log results.

Web Client

Access to your monitoring data anytime anywhere from any browser enabled device.

Alert Management

Pre-defined & custom alerts auto-notify you of issues via SMTP or SNMP.


Team Support

Manage users views and access to servers by roles for added security.

 
 

Postgres Enterprise Manager FAQ

General FAQs

Agent FAQs

Client FAQs

SQL Profiler FAQs

Visual Database Management

Postgres Enterprise Manager provides you with a single management console that allows you to visually manage all aspects of your PostgreSQL servers. You can start and stop PostgreSQL instances, visually change configuration parameters, manage user accounts and security, create and maintain databases, handle all storage management functions tables and associated objects, develop SQL code in a smart editor, perform general backup and restore operations, and register new servers re-using registration for all clients. Postgres Enterprise Manager is the only tool available with so many features and the ability to apply it graphically and easily over large PostgreSQL installations.

Sample Metrics

Availability
  Historical/current database availability in a timeline
Performance
  Long Running Queries
  Idle Transactions
  Last Vacuum/Analyze
Throughput
  Blocks Read/Buffer Hits
  WAL files
  Row Inserts,Updates,
Deletes per minute
     
Utilization
  Connections, Locks Held
  Database Size and Age
  # of Databases & Schemas
  # of Tables, Views, Functions
  # of Sequences
  # of Prepared Transactions
  # of Tuples Returned, Inserted, Updated, Deleted
  Sequential/Index scans
  Heap/Index Sizes
  # of Rows, Columns, Indexes, Rules and Triggers
  Table and Index bloat
     

Postgres Enterprise Manager™ Capacity Planning and Forecasting

Capacity Planning and Forecasting

Capacity Manager shines a bright light on your hardware utilization by allowing you to specify the automatic collection of desired performance statistics. Then, you can customize which metrics to analyze, including a historical trend analysis over specified blocks of time. The collected data and subsequent analysis allow you to forecast your resource consumption trends and help plan your data center upgrades or expansion. Capacity Manager also gives you the ability to customize your reports, viewing in graphs and tabular data.

 
 

Postgres Enterprise Manager Architecture

 

Architecture Diagram

 

Architecture Video (3 min.)

 
     
  Click to Enlarge   View large video  

View our installation videos

 

Installing the PEM Server

 

Installing the PEM Client

 
     
  View large video   View large video  
         
 

Installing the PEM Agent

 

Installing the SQL Profiler

 
     
  View large video   View large video