pgsnmpd 1.0 beta 1 was just released, and is available for download from http://pgfoundry.org/projects/pgsnmpd. pgsnmpd provides an SNMP interface for monitoring a PostgreSQL instance. This version supports RDBMS-MIB (RFC 1697) on PostgreSQL 8.x versions. Enjoy!