Re: Feature freeze date for 8.1 - Mailing list pgsql-hackers

From Bruno Wolff III
Subject Re: Feature freeze date for 8.1
Date
Msg-id 20050502200525.GA13959@wolff.to
Whole thread Raw
In response to Re: Feature freeze date for 8.1  (Rob Butler <crodster2k@yahoo.com>)
List pgsql-hackers
On Mon, May 02, 2005 at 12:29:33 -0700, Rob Butler <crodster2k@yahoo.com> wrote:
>  
> > One way to handle this is to have an option, set by
> > the client, that
> > causes the server to send some ignorable message
> > after a given period
> > of time idle while waiting for the client. If the
> > idleness was due to
> > network partitioning or similar failure, then this
> > ensures that the
> > connection breaks within a known time. This is safer
> > than simply having
> > the backend abort after a given idle period.
> 
> Another option is to have the client driver send some
> ignorable message instead of the server.  If the
> server doesn't get a message every timeout
> minutes/seconds + slop factor, then it drops the
> connection.  So libpq, JDBC, .net etc would all have
> to have this implemented, but the changes to the
> server would probably be simpler this way, wouldn't they?

Except it won't work, because the server is who needs to know about
the problem. If the network is down, you can't send a TCP RST packet
to close the connection on the server side.


pgsql-hackers by date:

Previous
From: "Marc G. Fournier"
Date:
Subject: Re: [pgsql-advocacy] Increased company involvement
Next
From: Bruce Momjian
Date:
Subject: Re: [pgsql-advocacy] Increased company involvement