Hi all,
I learned mysql has some sort of "top like" tool, to easily see what is going
on in the DB. AFAIK no such cmdline tool exists for Postgres (yet) ?
For my own monitoring, I have been using the ever simple "ps axfu" to show
processes and usage. I tried using the pgmonitor Tcl thingie, which was sort
of nice, but not what I really needed (console based would be ideal).
I also tested out Nagios, but found the typical problem of observing
inflicting on the performance. (If the frequency of checks was to be high
enough to really be useful they would actually produce a non negligeble load
on the server just by checking all clusters..)
What do other people use to monitor Postgres in a high availability setup ?
Any tools I am not aware of ? (must be, there is so much to Postgres by now..)
I know a lot of performance / monitoring data can be switched on and accessed
low level in postgresql, but have anyone else than Bruce (with his Pgmonitor)
done anything with regards to tools ?
--
Denis Braekhus - ABC Startsiden AS
http://www.startsiden.no