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 ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
