PostgreSQL Management Support

PostgreSQL is a highly-scalable, open source object-relational database management system. With more than 15 years of development history, it is quickly becoming the de facto database for enterprise level open source solutions.

Because Hyperic HQ uses PostgreSQL 8.0 as its built in database backend, we have aimed to provide the deepest, most comprehensive PostgreSQL monitoring available in any management solution. Hyperic HQ allows discreet management of both the server engine as well as every individual table in the system, thereby providing not only a vast assortment of metrics, but also control capabilities commonly associated with PostgreSQL monitoring and management such as vacuum, analyze, and vacuum full analyze. Performing these management tasks on an automated basis through HQ's integrated control infrastructure allows you to define policies such as reallocating free space through vacuum whenever the rate of deletes per minute on a table exceed a threshold.

Hyperic HQ aims to provide PostgreSQL users the monitoring and management capabilities typically found in database centric tools coupled with management support for the other technologies which, along with databases, are used in today.s enterprise environment. Its powerful application concept allows you to visualize monitoring data from your database tier alongside your business logic and presentation tiers by giving you the ability to measure how client activity is reflected across the various layers of your application infrastructure. For more information about our PostgreSQL plugin, please visit our HyperFORGE http://support.hyperic.com/confluence/display/hypcomm/PostgreSQL

Auto-Discover your hardware and PostgreSQL servers
Monitor every metric, log, and configuration for all PostgreSQL resources in your inventory
Identify problem resources with automatic baselines for every metric
Control all your PostgreSQL resources on-demand, on schedule, or in response to alerts
Alert on any measurement, log, or security event in your PostgreSQL environment