Long time no post - but I just got back home from the Netways Nagios Conference 2008 where I was invited to give a talk on "PostgreSQL Monitoring - Introduction, Internals And Monitoring Strategies for postgresql.org" so I figured it is time to say something again ...
I think the talk went pretty well and I got some very interesting feedback both in the session and afterwards not only on monitoring postgresql itself but also on concepts I mentioned only in passing like how the development process works (the commitfest concept was of considerable interest) and how the infrastructure is run and maintained without a single entity(as in company or person) "in control".
On the PostgreSQL side of things there was serious interest shown in adding/improving postgresql support in existing tools like NDOUtils because it seems that all the current and soon to be released tools about graphing data and doing reporting work rely in some form or another on NDO tracked data.
It also feels like some of those tools and approaches presented could potentially benefit a lot from some of the more advanced features postgresql has.
During my presentation I also mentioned check_postgres.pl as a "must have" for any kind of postgresql related monitoring done with nagios. This resulted in an interesting followup discussion with Ton Voon (lead developer on the nagios-plugins project) about adding at least a pointer to that plugin in their docs or maybe even looking into replacing the existing one.
All in all this was a really nice conference with a very interesting mix of people from quite different backgrounds and it is really impressive to see how much inroad nagios has made even into very large corporations and the whole ecosystem that has developed around it.
I guess I will try to be there again next year - and just in case anybody is interested my slides are available here and I think that video recordings will be available soon too.
I'm happy to announce that version 2.1.4 of check_postgres.pl is out. This is a Postgres monitoring script that can output information in Nagios, MRTG, or simple output. We're now checking 26 distinct Postgres metrics: a complete list of actions can b
Tracked: Sep 23, 23:52