Re: psql query gets stuck indefinitely

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