setting connection/ query timeout

["tamanna madaan" <tamanna.madan@xxxxxxxxxxxxxxx>]

Hi All

 

I am using postgres-8.1.2 . In postgresql.conf I have set :

 

#statement_timeout = 0

 

 I am executing the below query just to check if postgres is allowing connections or not .

 

psql -Uslon -d<db_name> -h <IP> -c "select 1;"

 

Sometimes this query gets stuck for unknown reason . So, for this particular query I want to set a timeout
. I dont want to change "statement_timeout" in postgresql.conf as this would affect all the connections/queries.
I just want to set timeout for above mentioned query . How can I do that ??

 

Moreover, Just in case there is some problem while getting connection to postgres while executing the above query ,
I want the query to exit . How can I set connection timeout for that ??

Thanks..
Tamanna