PGCon2007 - Confirmed
PGCon 2007
The PostgreSQL Conference
Speakers | |
---|---|
Joshua Tolley |
Schedule | |
---|---|
Day | 4 |
Room | SITE H0104 |
Start time | 11:30 |
Duration | 01:00 |
Info | |
ID | 19 |
Event type | Lecture |
Track | Performance |
Language | English |
Feedback | |
---|---|
Did you attend this event? Give Feedback |
pgsnmpd
Keeping tabs on PostgreSQL
pgsnmpd is a net-snmp-based monitoring daemon being developed for PostgreSQL 8.x. Initial versions will support RFC 1697 (http://www.faqs.org/rfcs/rfc1697.html) 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.