[check_postgres] check_postgres_query_runtime

[Guillaume Lelarge]

On Mon, 2013-08-26 at 19:43 +0000, Keith Ouellette wrote:
> I am trying to use the feature to execute a function in our database to get the response/delay time. Here is what I am trying and the response that I am getting. Any help would be greatly appreciated.
> 
> 
> 
> ./check_postgres_query_runtime -H 192.168.0.200 -o nagios --dbpass=hydrogen -db scadabase --queryname='bam."Notify_test"()' -w 1 -c 2
> ERROR: Invalid queryname option: must be a simple view name
> 

AFAICT, check_postgres doesn't expect to see quotes in the name of the
view/function. It probably should get fixed, but in the mean time, don't
use uppercase letters in you functions/views names.


-- 
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com