Re: psql query gets stuck indefinitely

[Craig Ringer <ringerc@xxxxxxxxxxxxx>]

 On 11/28/2011 05:30 PM, tamanna madaan wrote:

Hi All

 

I have postgres installed in cluster setup. My system has a script  which executes the below query on remote system in cluster.

 

psql -t -q -Uslon -h<hostip> -d<dbname> -c"select 1;"

 

But somehow this query got stuck. It didnt return even after the remote system( on which this query was supposed to execute) is rebooted . What could be the reason ??

The issue will most likely be related to the network or to the client-side host. Perhaps the client machine changed IP addresses (maybe as part of a switch from WiFi to wired or similar) ?

Check the man page for psql in 9.1; I think client-side keepalive support got committed for 9.1 . If it didn't, you can always set it globally for all TCP/IP connections on your system. See eg http://tldp.org/HOWTO/TCP-Keepalive-HOWTO/usingkeepalive.html .

--
Craig Ringer