Re: support for keep alive option - Mailing list pgsql-odbc

From Hiroshi Inoue
Subject Re: support for keep alive option
Date
Msg-id 52CD392D.80502@tpf.co.jp
Whole thread Raw
In response to Re: support for keep alive option  (Heikki Linnakangas <hlinnakangas@vmware.com>)
Responses Re: support for keep alive option
List pgsql-odbc
(2014/01/08 18:20), Heikki Linnakangas wrote:
> On 01/08/2014 01:48 AM, Inoue, Hiroshi wrote:
>> Hi Barry,
>>
>> Sorry for the late reply.
>>
>> (2014/01/02 23:02), Barry Bell wrote:
>>> Thanks, Alright with me to add the patch in
>>>
>>> But you may want to Hiroshi (He does the office and unofficial ODBC
>>> driver releases),
>>>
>>> Hiroshi, what do you think of this?
>>
>> OK I would introduce the functionality.
>
> I don't think it should be enabled by default. It's common to expose
> keepalive and other TCP settings as an option, like libpq does, but it's
> not usually enabled by default, and it might be an unwelcome surprise to
> some existing applications.
>
> In particular, if you have a dialup connection, you do *not* want an
> idle connection to keep sending periodic keep-alives, because keeping
> the connection open costs money. It's not as big a problem these days as
> it used to be, but still.

Libpq's keepalives option is on by default. So currently psqlodbc's
keepalive is enabled when libpq is used(in case ssl used etc) otherwise
it is disabled.
Though I am about to enable keepalive by default, I'm not sure which
  should be the default.

regards,
Hiroshi Inoue




pgsql-odbc by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: support for keep alive option
Next
From: Hiroshi Inoue
Date:
Subject: Re: Error installing ODBC Driver