>> 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. I think pgwatch from Cybertec resembles the Oracle management console a bit. Sure, it's not that advanced and it does not know how to analyze the collected data, but it's something to start with - see this http://www.cybertec.at/en/pgwatch I guess it's almost the same as the Nagios plugin, just without Nagios. A long time ago I've started a project to do something like this (collect and analyze the data) - it's called pgmonitor and it's available on SourceForge: http://pgmonitor.sf.net. I've been working on it occasionally (and the patch I've submitted a related patch in January), but the development stagnates recently. So if there anyone who'd like to cooperate on that with me (bring some new ideas, code a bit, design a better UI, whatever), let me know. regards Tomas -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
