Re: PostgreSQL monitoring

Поиск
Список
Период
Сортировка
Искать
От
Jaume Sabater
Тема
Re: PostgreSQL monitoring
Дата
Msg-id
3786f7bb0901190756h5079eb3ap12bcedbe4ff2053@mail.gmail.com
Ответ на
PostgreSQL monitoring (Marcelo Martins)
Список
Дерево обсуждения
PostgreSQL monitoring Marcelo Martins <pglists@zeroaccess.org>
Re: PostgreSQL monitoring "Jaume Sabater" <jsabater@gmail.com>
Re: PostgreSQL monitoring Marcelo Martins <pglists@zeroaccess.org>
Re: PostgreSQL monitoring Vladimir Rusinov <vladimir@greenmice.info>
Re: PostgreSQL monitoring Jaume Sabater <jsabater@gmail.com>
Re: PostgreSQL monitoring Vladimir Rusinov <vladimir@greenmice.info>
Re: PostgreSQL monitoring Rodrigo Hjort <rodrigo.hjort@gmail.com>
Re: PostgreSQL monitoring Cédric Villemain <cedric.villemain@dalibo.com>
Re: PostgreSQL monitoring Vladimir Rusinov <vladimir@greenmice.info>
Re: PostgreSQL monitoring Cédric Villemain <cedric.villemain@dalibo.com>
Re: PostgreSQL monitoring Johann Spies <jspies@sun.ac.za>
Re: PostgreSQL monitoring ashok raj <ashokexplorer@gmail.com>
Re: PostgreSQL monitoring Cédric Villemain <cedric.villemain@dalibo.com>
On Mon, Jan 19, 2009 at 4:38 PM, Marcelo Martins  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"
В списке pgsql-admin по дате отправления
От: Scott Marlowe
Дата:
Сообщение: Re: tuning tips, speed problem
От: Cédric Villemain
Дата:
Сообщение: Re: PostgreSQL monitoring
FAQ