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 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 > from the p

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 Farina

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 wrote: > On 9/4/12 12:12 AM, charles_xie wrote: > > Hi all, > > i have 5 servers that have been installi

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 Daniel Farina
On Tue, Sep 4, 2012 at 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 > pos