Re: psql hanging

From: Steve Crawford <scrawford(at)pinpointresearch(dot)com>
To: Trevor Talbot <quension(at)gmail(dot)com>
Cc: Richard Huxton <dev(at)archonet(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: psql hanging
Date: 2007-09-14 00:10:46
Message-ID: 46E9D186.7040903@pinpointresearch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Andrew Hammond 2007-09-14 00:22:32 Re: [HACKERS] AutoVacuum Behaviour Question
Previous Message Bruce Momjian 2007-09-14 00:04:12 Re: AutoVacuum Behaviour Question