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
