09.03.0100 is not compatible with Postgres-9.1.x

From: "Itnal, Prakash (NSN - IN/Bangalore)" <prakash(dot)itnal(at)nsn(dot)com>
To: "pgsql-odbc(at)postgresql(dot)org" <pgsql-odbc(at)postgresql(dot)org>
Subject: 09.03.0100 is not compatible with Postgres-9.1.x
Date: 2014-03-07 11:43:22
Message-ID: 6C8E163ED7EF5846B2F44CDBC63300111E38A0@SGSIMBX006.nsn-intra.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Hi,

We trying to migrate latest psqlODBC driver (09.03.0100) in our product. Our product runs postgres server 9.1.x.

Server version: 9.1.11
psql (9.1.11)
Type "help" for help.

DBTestHSBPostgres=# \q

psqlODBC version: 09.03.0100

What are the difference?
We enabled the Nagle Algorithm in psqlODBC driver to get better performances (this done after trial error).

What is error?
As soon as we start database client it throws below error. The same works fine with 09.01.200.

[unixODBC]Could not connect to the server;Could not set socket to NODELAY. (101)
isDBServerUp(): failed to connect to the db server, retrying after 1 second

Why is the upgrade?
We are upgrade psqlODBC driver because we have seen some unusual crashes in psqlODBC driver which are hard to reproduce. So we are trying to get the latest psqlODBC driver which seems to have quite a few bug fixes.

We have seen better performance with Nagle Algorithm enabled and not disabling TCP_NODELAY. I don't know if disabling TCP_NODELAY may result in performance degradation. Anyway I can try this option, but at the same time I wanted to understand is that the only way! Or there is something really missing!

It would be great if someone help me to resolve this issue!

--
Regards,
Prakash I.

Browse pgsql-odbc by date

  From Date Subject
Next Message Przemyslaw Rzepecki 2014-03-07 12:47:00 Re: SQLFetchScroll with SQL_ATTR_ROWS_FETCHED_PTR closing statement.
Previous Message Heikki Linnakangas 2014-03-07 09:59:28 Re: SQLFetchScroll with SQL_ATTR_ROWS_FETCHED_PTR closing statement.