In response to Bobby Dewitt <bdew...@appriss.com>: > I think by AWR he is referring to Oracle's Automatic Workload Repository. It > automatically gathers information on wait events, object usage, session and > system statistics, etc. It also provides a nice report of what is going on > in your database and can help identify bottlenecks that may be causing > performance issues. I'm still new to PostgreSQL, but I don't believe there > is anything available like this. > > As far as monitoring database availability goes, I'm working on a plugin for > Oracle's OEM (Oracle Enterprise Manager) that monitors if the server is up or > down, if there are any blocking sessions, and what percentage of > max_connections is being used. It sends alerts for these events based on > different thresholds. However, I'm still in the beginning stages of > development and it probably won't be available for a few months. > > I've heard of others using Nagios to monitor PostgreSQL, and EnterpriseDB is > supposedly building an OEM type tool but it won't be available until later > this year. > > Monitoring PostgreSQL has been a big issue for us since beginning to migrate > from Oracle, so if anyone else has any experience with this I would love to > hear other suggestions.
Most of our monitoring is done through Nagios and Cacti by extracting data from log files or pg_stat_activity, pg_locks and other system tables. It takes a bit of know-how to know what tables to get the data you want from, and a comprehensive monitoring tool would definitely make it easier on newbies. -- Bill Moran http://www.potentialtech.com http://people.collaborativefusion.com/~wmoran/ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
