[PERFORM] HELP!!!-----Need to Sql commands to monitoring Postgresql

2012-09-06 Thread charles_xie
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

Re: [PERFORM] HELP!!!-----Need to Sql commands to monitoring Postgresql

2012-09-06 Thread Daniel Farina
On Tue, Sep 4, 2012 at 12:12 AM, charles_xie xqwyy...@163.com 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

Re: [PERFORM] HELP!!!-----Need to Sql commands to monitoring Postgresql

2012-09-06 Thread Josh Berkus
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 .

Re: [PERFORM] HELP!!!-----Need to Sql commands to monitoring Postgresql

2012-09-06 Thread Steven Crandell
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

Re: [PERFORM] HELP!!!-----Need to Sql commands to monitoring Postgresql

2012-09-06 Thread charles_xie
Hi, Thanks for your advice.i know the basic monitoring skill,because the postgresql database is used for the factory production , so I hope they can run normal and exert more perfect performance. so i need to be considered from the point of view ,eg : threading ,locks and so on. Daniel

Re: [PERFORM] HELP!!!-----Need to Sql commands to monitoring Postgresql

2012-09-06 Thread Daniel Farina
On Thu, Sep 6, 2012 at 6:50 PM, charles_xie xqwyy...@163.com wrote: Hi, Thanks for your advice.i know the basic monitoring skill,because the postgresql database is used for the factory production , so I hope they can run normal and exert more perfect performance. so i need to be considered