postgres stats and opennms

Question

What is the best (or easiest?) to monitor postgres 8.4 stats in OpenNMS 1.76?

SNMP? How?

isn't that going to be using the tool to monitor part of itself, which would cause more traffic to itself? — warren, Sep 07 '09 at 07:20
yes, monitoring tools can generate additional traffic- but often the benefits of observability outweigh the additional traffic overhead. — robbyt, Sep 07 '09 at 18:13

score 2 · Accepted Answer · answered Dec 18 '10 at 08:17

2

There's the already mentioned pgsnmpd but it doesn't seem to be maintained actively (last release in August 2007). I'd rather recommend using the check_postgres Nagios plugin with the NRPE plugin of OpenNMS.

answered Dec 18 '10 at 08:17

joschi

21,387
3
47
50

Thanks! I didn't realize that OpenNMS could read performance information via NRPE! A quick google search yields this great article: http://honglus.blogspot.com/2009/03/integrating-nagios-plugin-with-opennms.html – robbyt Dec 19 '10 at 07:46

score 1 · Answer 2 · answered Sep 22 '09 at 11:55

A quick google on "postgresql snmp" returned the following, which should allow you to monitor the database that OpenNMS is using from itself:

http://www.postgresql.org/about/press/features83 links to http://pgsnmpd.projects.postgresql.org/ for SNMP

Hopefully monitoring itself doesn't create a feedback loop :)

postgres stats and opennms

2 Answers2