Postgres Enterprise Manager™
Monitor, manage and tune Postgres databases easily!
DBAs who use Postgres Enterprise Manager 5.0 will benefit from increased productivity, ease-of-use, data integration, and dashboards tailored to their unique Postgres infrastructure. Easily and effectively monitor, alert, manage and tune large numbers of Postgres database servers from an integrated, customizable graphical console. No other tool allows a single DBA to care for more databases than Postgres Enterprise Manager!
|Custom monitoring probes|
|Rich alerting rules including time-of-day control|
|Log Analysis Expert to report on key usage statistics|
|Easy setup with auto-discovery of managed servers|
|Flexible remote monitoring capabilities|
Postgres Enterprise Manager QT
The only full featured database infrastructure monitoring package for Postgres installations. Designed and built by Postgres community experts, no other tool monitors what really matters like Postgres Enterprise Manager.
Adding instances to monitor and alert is simple with auto-discovery of database servers.
225+ pre-configured probes designed by community experts monitor instantly.
Access your monitoring data anytime anywhere from any browser enabled device.
Pre-defined & custom alerts auto-notify you of issues via SMTP or SNMP alerts.
Add to the 225+ ready to use out-of-the-box probes by creating your own.
Configure alert recipients by low/medium/high priority and by time of day.
Monitor your database servers remotely without having to install a local monitoring agent.
You can create views reflecting mission critical metrics specific for your installation.
Time period zoom, drill down chart data and graphs, and cross hierarchy views.
All the essential Postgres management tools together in an easy-to-use environment. Postgres Enterprise Manager enables a single DBA to easily manage more databases than any other tool of its kind.
Manage all your database objects and work with data from a point and click GUI.
Best practice suggestions for configurations, schema design and security.
Manages the fine grained auditing features in Postgres Plus Advanced Server.
Configure multiple databases at once and view consolidated log results.
Analyze a variety of statistics on locks, queries and more collected by the Log Manager.
Manage users views and access to servers by roles for added security.
Distributed architecture for flexible and efficient 'management en masse' of large installations.
Provides formal trend analysis reports for storage and hardware plans.
A variety of tools tackles every aspect of Postgres tuning for both DBAs and Developers, and for single simple queries to multiple complex jobs run in batch.
At-a-glance views for I/O, storage, memory, user/session activity, and wait stats.
Configures machine utilization and application workload settings for each database.
Recommends and deploys new table indexes based on specific troublesome queries.
Use a Session Wait Analysis Dashboard to view current wait events for Advanced Server.
An efficient tool for troubleshooting and optimizing slow SQL jobs.
Developers will appreciate Postgres Enterprise Manager for server side programming and debugging in a GUI as well as getting help in finding and optimizing slow running SQL.
Construct SQL queries by hand or using a drag and drop GUI editor.
Easily step through server side stored procedures and triggers in yourSQL code.
Quickly find and optimize slow running SQL commands in large SQL jobs.
Quickly build up new database schemas to test your applications.
Developers can view table data, or view and update with proper permissions.
Q. What versions of PostgreSQL can PEM monitor?
Q. What versions of Postgres Plus Advanced Server can PEM monitor?
A. PEM can monitor all active distributions of Postgres Plus Advanced Server that have not reached their end of life (EOL).
Q. Do I need to purchase a database subscription to use PEM?
A. Yes. All EDB Tools for Monitoring, Management, Performance, and High Availability are distributed as part of either a Postgres Plus Standard Edition or Enterprise Edition database subscription.
Q. My monitored databases are v9.1 but the PEM Server installs v9.4 for its own use, do I need to purchase a subscription for the PEM Server?
A. You do not need to purchase a subscription for the PEM Server database. Your database subscription entitles you to the entire PEM installation (Server, Agents and Client including the PostgreSQL database used by the PEM Server) for all the databases covered by your Standard Edition or Enterprise Edition subscription.
Q. Do I need a product key to install PEM?
Q. What happens after 60 days?
Q. How do I get a product key?
Q. How does Postgres Enterprise Manager compare with Nagios monitoring for PostgreSQL?
A. The main difference is that Nagios is *just* an alerting system - and because it's not designed to work specifically with Postgres, it's not very efficient in the way it collects monitoring data. To give an example, for every individual metric that Nagios monitors on the database server, it'll run a query, whereas PEM is designed to collect as much data as possible - for example, it'll collect the stats of all tables in a single query, instead of one query per stat, per table.
PEM also has: a) Storage of historic metrics data, with predictive reporting to allow you to look at previous performance and predict what things will look like in the future, b) a SQL Profiler to help track down queries that aren't performing optimally, c) all the tools and features of pgAdmin, with a centralized directory of servers to help teams manage large installations effectively, d) Postgres Expert to check that server configurations (schemas, security, key parameters) look sane, and haven't been misconfigured, e) a Log Manager for configuring logs en masse, and much more.
Finally in addition to SNMP and SMTP alerting Enterprise Manager's alerting mechanism is a little more flexible than Nagios as it adds the concept of alert levels, allowing you to specify low, medium and high alert levels, rather than just alert or not alert like Nagios (technically you could do that in Nagios by creating multiple identical alerts with differing thresholds, but that would be difficult to manage).
Q. Does running agents create much overhead?
Q. Can PEM agents monitor Postgres instances on public and private clouds the same as on-premise instances?
Q. Can PEM agents monitor Postgres instances running in virtual machines such as those provided by VMWare?
Q. Is it best practice to leave the agents running all the time? If not, is there a scheduler to automatically switch them on and off?
A. The agents need to be left on all the time to collect data in a consistent manner that will be accurate when displayed and analyzed in the PEM Client tools. There is no scheduler for switching them on or off.
Q. Do PEM agents support Apple OSX for the Mac?
Q. Can I install multiple instances of the PEM Client?
Q. Where can I find the documentation for the Client?
Q. Is there a browser based version of the client?
A. Yes, the Browser based client is installed automatically and is supported on Firefox, Safari, Chrome and IE.
Q. Is there a user rights management option?
Q. What kind of tasks can DBAs perform with PEM on hosts that do not run a PEM agent?
A. Anything that can be done with pgAdmin (i.e. all administrative tasks). In addition, they can use the SQL Profiler in ad-hoc mode (i.e. cannot schedule traces).
Q. Can the PEM Client manage Postgres instances on public and private clouds the same as on-premise instances?
Q. Can the PEM client manage Postgres instances running in virtual machines such as those provided by VMWare?
Q. Can PEM perform administration tasks such as provisioning and upgrading Postgres servers?
Q. Can PEM help administrators control and configure features such as partitioning, streaming replication or hot standby available in Postgres?
A. Only to the degree that pgAdmin can.
Q. Is it possible to ring fence environments and create separate development, test, QA and production environments where PEM users would be restricted to a specific environment? - or does PEM give access to all and any Postgres instance on the network?
A. PEM has a Team feature which allows you to restrict which PEM users can see and access selected monitored servers based on roles.
Q. What would be the best practice for customers who want to use PEM and keep development, test, QA and production environments separated?
A. Install and run separate PEM servers for each. There is no additional charge for installing more than 1 PEM server or Client.
Q. Can PEM provide high level SLA reports for the DBA's management? - ie. reports to prove that the platform is running well against SLAs to business managers or customers.
A. Yes, with the Log Analysis Expert Tool.
Q. How do you log onto a monitored server using a different user name?
A. Right-click the server, select Properties, and then change the user ID you wish to login using. That info is stored in the PEM server directory on a per-user basis, so each user can login with a different role.
SQL Profiler FAQs
Q. Does the SQL Profiler work in a MAC environment?
Q. Does the SQL Profiler work on community PostgreSQL versions?
A. The SQL Profiler only works on the EnterpriseDB packaged distribution of PostgreSQL. We will support other distributions of PostgreSQL but you will need our assistance in creating a SQL Profiler binary that is compatible with the running server or it may fail to load or even crash the server. Third party distributions of PostgreSQL may use different build settings or use different compilers which could cause binary incompatibilities, so its important to work with our team for a trouble free installation.
Q. Is there a way to identify users that are currently executing SQL Profiler traces?
A. You can list the current traces on a server using the Cleanup option and see the owner, size, status and age of traces, and stop any that are currently running.
How to buy this tool
EDB Tools for Performance, Scalability, High Availability, and Management
Tools are included in database subscription purchases as checked and noted in the table on the Postgres Plus Subscription Plans and Prices page.