Re: PostgreSQL server does not notice that clients have disappeared - Mailing list pgsql-general

From Maciek Sakrejda
Subject Re: PostgreSQL server does not notice that clients have disappeared
Date
Msg-id CAKwe89CrCoN8OW6kbo7=E5A-cPfje+vxbd7ctRVLyVWrYFYfDg@mail.gmail.com
Whole thread Raw
In response to PostgreSQL server does not notice that clients have disappeared  (Al Eridani <al.eridani@gmail.com>)
Responses Re: PostgreSQL server does not notice that clients have disappeared  (Al Eridani <al.eridani@gmail.com>)
List pgsql-general
On Fri, Jan 23, 2015 at 12:08 PM, Al Eridani <al.eridani@gmail.com> wrote:
Is this still true on the 9.x versions? Thanks!

It is, unfortunately. If your client kicks off a 12h query and immediately closes the TCP connection, Postgres won't notice until the query has completed.

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: CLOG read problem after pg_basebackup
Next
From: Al Eridani
Date:
Subject: Re: PostgreSQL server does not notice that clients have disappeared