Last weekend, I presented “Monitoring Your PostgreSQL Database with Hyperic” at PG Con West and while creating my slides, I looked at many other options of how to monitor production databases. I was impressed by the sheer number of options available for monitoring PostgreSQL with 19 project listed on PgFoundry, but I was also disheartened by those same number of options. Many of the projects have overlapping capabilities each written in the developer’s language of choice. Also, none of the projects provided an overarching solution that would allow administrators to monitor complex PostgreSQL deployments. This is where Hyperic fits. Hyperic allows administrators to create monitoring across complex PostgreSQL architectures such as show below.

Without an integrated solution that will monitor the different pieces infrastructure, tracking down potential bottlenecks becomes a nightmare. Hyperic can be overkill in some small environments, but its model is something the PostgreSQL community should consider instead of writing yet another monitoring tool.