PGCon2007 - Confirmed

PGCon 2007
The PostgreSQL Conference

Joshua Tolley
Day 4
Room SITE H0104
Start time 11:30
Duration 01:00
ID 19
Event type Lecture
Track Performance
Language English


Keeping tabs on PostgreSQL

pgsnmpd is a net-snmp-based monitoring daemon being developed for PostgreSQL 8.x. Initial versions will support RFC 1697 ( and the associated RDMBS-MIB on Linux, but future versions will include an expanded MIB to keep track of all kinds of useful information. We will demonstrate pgsnmpd as well as its interaction with a few common software packages to provide realtime alerts and display historical trends.

Monitoring application performance and resource utilization is critical to maintaining stability and preventing downtime. Whole hosts of applications exist to consume monitoring data via SNMP and generate alerts when values exceed predefined thresholds, store information for historical purposes, analyze performance trends, etc. pgsnmp will implement RFC 1697, an SNMP MIB describing features common to most relational database systems, as well as an expanded PostgreSQL-specific MIB, exposing information from pg_catalog and information_schema, for example.

In combination with available monitoring software, pgsnmpd will allow administrators to see such things as trends in index usage, data growth, transaction rate, etc. We will provide examples using ubiquitous SNMP-based monitoring systems such as MRTG, Cacti, and RRDTool to show trend monitoring, and Nagios to provide realtime alerts about critical events.