Re: PostgreSQL monitoring

Cool, I have actually been trying out Zabbiz 1.6.x now since I like it
better than munin.

Thanks,

Marcelo
PostgreSQL DBA
Linux/Solaris System Administrator

On Jan 19, 2009, at 9:56 AM, Jaume Sabater wrote:

> On Mon, Jan 19, 2009 at 4:38 PM, Marcelo Martins <pglists@zeroaccess.org
> > wrote:
>
>> Do you guys have any suggestions on monitoring tools for postgresql
>> that
>> would provide graphing of data & alerts ?
>> I have looked and tried out hyperic, munin, Nimbus but was hoping to
>> something better.
>
> To monitor I use the following:
>
> - pg_osmem: http://www.kennygorman.com/wordpress/?p=250
> - pg_buffercache (contrib package in Debian)
> - pg_top: http://ptop.projects.postgresql.org/
> - ps
> - pgd: http://www.kennygorman.com/wordpress/?p=260
> - iotop: http://guichaz.free.fr/iotop/
>
> And I am in the process of writing a bunch of scripts that the Zabbix
> agent will execute to feed the server with information, so that alerts
> and graphs can be produced.
>
> --
> Jaume Sabater
> http://linuxsilo.net/
>
> "Ubi sapientas ibi libertas"