Intermapper command line probe with snmpget

Some people might need to know how long it took to process those SQL statements, with an unreasonably long time meaning your attention is needed before users start to call.Д¬hanges to database permissions might raise a false warning. You might or might not need more than that. Reading back the same row, though, should be solid evidence of life.ДЄ program like that tells you that the dbms is running and processing, and that one specific database is online. This should be run from a client computer, not on the server itself.ДЄ failed write should raise an error, but I imagine there could be some esoteric failure scenarios where that might not happen. You might not need anything more than a timestamp. I can't help you with Intermapper today, but the programming depends in part on what 'alive and kick'n' means to you.ДЄ fairly bulletproof way to program it would be to have a cron job write a row into a table in one transaction, and read it back in another transaction. They have Nagios support for commandline probes and there are plenty Nagios-PostgreSQL plugins available.ДЄnd of course you can use the contributed probes page to get enough examples - the MS-SQL probe in the 'Application Monitoring Probes' section might be a good start.On Linux/Unix writing a script using psql to connect to the DB and issue some silly command seems not to complicated too. use 'command line probes' which basically calls an external program.define your own probe type - by hacking some XML.A quick glance over it leaves three options: Regarding Plan B: The support page has a document describing the process for creating custom probes. So the best solution is to call them and persuade them to provide such a probe by default - if they don't do that already somewhere. This CALLS for either a generic JDBC-probe or at least one for PostgreSQL right from the start.

It also stores its own data in PostgreSQL. Otherwise: InterMapper said to be written in Java. You can connect both right out of the box(es). pgsnmpd is a SNMP agent for PostgreSQL readily available. According to Wikipedia InterMapper supports SNMP.

Intermapper command line probe with snmpget