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 <j...@agliodbs.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....@sanmina-sci.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@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-performance >