Re: Postgres 9.4 + unixODBC on Centos 6.5 problem connecting localhost postgres instance with isql ODBC commandline client - SOLVED

"Stefan Viljoen" <viljoens@verishare.co.za> writes:
> I managed to solve this on Centos 6.5 by downgrading to Postgres 9.0 and
> ODBC is now working fine:

Hm.  That should not have fixed anything, because there for sure have not
been any basic protocol-level changes since 9.0.

Looking back at your earlier messages, I notice that you are using
the Red Hat-supplied unixODBC package:

> # yum list installed | grep ODBC
>
> unixODBC.x86_64         2.2.14-14.el6   @base
> unixODBC-devel.x86_64   2.2.14-14.el6   @base

but the Postgres ODBC driver seems to be coming from PGDG:

> # yum list installed | grep postgres
>
> postgresql94.x86_64     9.4.4-1PGDG.rhel6
> postgresql94-contrib.x86_64
> postgresql94-devel.x86_64
> postgresql94-docs.x86_64
> postgresql94-libs.x86_64
> postgresql94-odbc.x86_64
> postgresql94-odbc-debuginfo.x86_64
> postgresql94-server.x86_64

An all-Red-Hat solution for this would look like

Installing:
 postgresql-odbc   x86_64   08.04.0200-1.el6    rhel-6-workstation-rpms   267 k
Installing for dependencies:
 postgresql-libs   x86_64   8.4.20-3.el6_6      rhel-6-workstation-rpms   202 k
 unixODBC          x86_64   2.2.14-14.el6       rhel-6-workstation-rpms   378 k

So now I'm suspicious that there's some incompatibility between the ODBC
driver that Devrim is shipping and the admittedly-pretty-old unixODBC
manager in RHEL6.

(I haven't worked for Red Hat in a couple of years, but I'm fairly sure
that when I left, their ODBC packages would still talk to current Postgres
server versions, because I recall testing that.  However, I never tested
the combination of their unixODBC with the PGDG packaging of the ODBC
driver...)

            regards, tom lane