[check_postgres] [resolved]error custom_query

[webmaster]

Hello

thank you you are right
sorry for the noise

philippe

Le 28/07/2013 03:33, Greg Sabino Mullane a écrit :
> On Sun, Jul 28, 2013 at 12:39:56AM +0200, l3w0rm wrote:
>> ./check_postgres.pl -H=10.8.0.18 --dbuser=xxxxx --dbpass=xxxxx
>> --db=bestofdates --critical=5000 --action=custom_query --query="select
>> count(*)  from subscribe where registered= 't' "
>> POSTGRES_CUSTOM_QUERY UNKNOWN: DB "bestofdates" (host:10.8.0.18) 
>> Format
>> invalide renvoyé par la requête personnalisée | time=0.06s 
>> count=2;;5000
> 
> See the documentation on the "custom_query" action. One of the columns
> must be named "result". So you might perhaps want this:
> 
> --action="select count(*) AS result FROM subscribe WHERE 
> registered='t'"
> 
> http://bucardo.org/check_postgres/check_postgres.pl.html#custom_query