Skip site navigation (1) Skip section navigation (2)

Re: Client connection lost; still in the task list

From: "Didier Gasser-Morlay" <didiergm(at)gmail(dot)com>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Client connection lost; still in the task list
Date: 2008-04-23 05:28:02
Message-ID: 608b66ce0804222228u158049b1pd2ca5d02e47703b8@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
You're right, this morning most connections had been freed.

I have seen that the tcp_keepalive
 is 7200 second, I'll shorten that to see.

thanks

Didier


On Tue, Apr 22, 2008 at 7:29 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> "Didier Gasser-Morlay" <didiergm(at)gmail(dot)com> writes:
>  > So my question is what makes PostgreSQL realise that a connection is
>  > dead ? when will it drop it and free the connection ?
>
>  It'll drop it when the kernel tells it the connection is dead.
>  Standard TCP timeouts are measured in hours, though.  You might
>  be able to get a shorter timeout to be applied by fooling with
>  the "keepalive" parameters, if those can be adjusted on your platform.
>
>                         regards, tom lane
>

In response to

pgsql-novice by date

Next:From: Didier Gasser-MorlayDate: 2008-04-23 16:21:16
Subject: restoring with pg_restore
Previous:From: Tom LaneDate: 2008-04-22 23:59:00
Subject: Re: pgoptions syntax?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group