Re: HELP!!!-----Need to Sql commands to monitoring Postgresql

Also probably some good info to be mined out of postbix.
http://www.zabbix.com/wiki/howto/monitor/db/postbix/monitor_postgres_with_zabbix

On Thu, Sep 6, 2012 at 12:44 PM, Josh Berkus <josh(at)agliodbs(dot)com> wrote:

> On 9/4/12 12:12 AM, charles_xie wrote:
> > Hi all,
> > i have 5 servers that have been installing postgresql .In order
> to
> > know the postgresql working status and monitor them ,moreover i don't
> want
> > to use the monitor tools .I want to use the SQL commands to monitoring
> > postgresql system . please suggest any SQL COMMANDS to work
> successfully.if
> > you have some good suggestion ,you can email to me
> > (charles(dot)xie(at)sanmina-sci(dot)com) or sky :xqwbx163
>
> Actually, the Nagios extension for PostgreSQL, check_postgres.pl, has a
> really good, very complete set of queries in its code. You could mine
> them from there.
>
> --
> Josh Berkus
> PostgreSQL Experts Inc.
> http://pgexperts.com
>
>
> --
> Sent via pgsql-performance mailing list (pgsql-performance(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-performance
>