>> 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