Re: support for keep alive option

Поиск
Список
Период
Сортировка
От PG User
Тема Re: support for keep alive option
Дата
Msg-id CAB7tN8ZPAFOGzs-6Pa3ZC6ANWt9e7B_RmLpvT6r_kYO6kp+q_w@mail.gmail.com
обсуждение исходный текст
Ответ на Re: support for keep alive option  (Heikki Linnakangas <hlinnakangas@vmware.com>)
Ответы Re: support for keep alive option
Список pgsql-odbc
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@vmware.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

В списке pgsql-odbc по дате отправления:

Предыдущее
От: Rob Emery
Дата:
Сообщение: Fwd: Error installing ODBC Driver
Следующее
От: Bart Klein Ikink
Дата:
Сообщение: Re: Database link from Postgres to Oracle using ODBC