OK 😊
This is now in CVS. I ported the monitoring package to PG as best as I can, given that much of it is Oracle specific (Cassandracle, etc). I added the new watchdog-procs file posted by Andy above. I've been using it for the past couple days (Oracle and PG) and it's reporting errors properly so far.
In regards to the monitoring package, I had to add a parameter to specify command-line options to send to 'top'. On my version (procps v. 2.07), I had to send it '-b -n 1'. I also had to adjust the top-scraper code, cuz the columns were in a different order. It should still work on whatever version it used to work (Solaris?).
Things to do:
- figure out why ad_monitoring_analyze_tables isn't working in Oracle
- try to create a PG replacement for Cassandracle
- Use templating (currently it just spits out HTML in the tcl pages)
But, it works for my main purpose - getting errors mailed to me from my PG site. (Note that you need to install the package, mount it on your site-map, set the parameters and then *restart* the server so that it schedules the watchdog-procs appropriately)
