In response to Bobby Dewitt <Bdewitt@xxxxxxxxxxx>: > 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
