Re: support for keep alive option

Hi All,
Thank you very much for your thoughts and discussions.

I need a last favor:
Is it possible for you to add functionality to postgres odbc version 9.x
(latest) as well as 8.4.2?

Thanking you.

- Nachiket

On Wed, Jan 8, 2014 at 4:06 AM, Heikki Linnakangas
<hlinnakangas(at)vmware(dot)com>wrote:

> On 01/08/2014 01:40 PM, Hiroshi Inoue wrote:
>
>> (2014/01/08 18:20), Heikki Linnakangas wrote:
>>
>>> 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.
>>
>
> Oh, I didn't realize that.
>
>
> 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.
>>
>
> I guess it would be best to enable it by default in psqlodbc as well, then.
>
> - Heikki
>