Request a Demo
Home   >   mailing lists

Re: Client connection lost; still in the task list - Mailing list pgsql-novice

From Didier Gasser-Morlay
Subject Re: Client connection lost; still in the task list
Date
Msg-id [email protected]
Whole thread Raw
In response to Re: Client connection lost; still in the task list  (Tom Lane <[email protected]>)
List pgsql-novice
Tree view 
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 <[email protected]> wrote:
> "Didier Gasser-Morlay" <[email protected]> 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
>

pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: pgoptions syntax?
Next
From: "Didier Gasser-Morlay"
Date:
Subject: restoring with pg_restore