Re: psql hanging - Mailing list pgsql-general

From Steve Crawford
Subject Re: psql hanging
Date
Msg-id 46E9D186.7040903@pinpointresearch.com
Whole thread Raw
In response to Re: psql hanging  ("Trevor Talbot" <quension@gmail.com>)
List pgsql-general
Trevor Talbot wrote:

> Unless psql is turning on keepalive or similar, or the OS is forcing
> it on by default, there are no timeouts for idle TCP connections.  If
> the command was transported to the server successfully and psql was
> just waiting for a result, the connection is idle and nothing will
> happen if the server end suddenly goes away.

This is the most likely explanation - fits the symptoms.

Cheers,
Steve





pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: AutoVacuum Behaviour Question
Next
From: "Andrew Hammond"
Date:
Subject: Re: [HACKERS] AutoVacuum Behaviour Question