From: | "Stefan Viljoen" <viljoens(at)verishare(dot)co(dot)za> |
---|---|
To: | <pgsql-odbc(at)postgresql(dot)org> |
Cc: | 'Devrim GÃœNDÃœZ' <devrim(at)gunduz(dot)org> |
Subject: | Re: Postgres 9.4 + unixODBC on Centos 6.5 problem connecting localhost postgres instance with isql ODBC commandline client - SOLVED |
Date: | 2015-07-22 13:47:32 |
Message-ID: | 002d01d0c484$f523b6b0$df6b2410$@verishare.co.za |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
Hi Tom
Thanks for the answer.
Yes, it turned out to be an incompatibility of some kind.
I downgraded the Postgress instance to 9.0 and immediately everything started working.
I suspect that the very old unixODBC (2.2.14) that ships with a fully updated Centos 6.5 (also old) is simply incompatible with the psqlodbc driver shipped with Postgres 9.4
Everything is now working fine on Postgres 9.0
Maybe put up a note somewhere relevant that (maybe) Centos 6.5 stock unixODBC cannot talk to Postgres 9.4's ODBC driver?
9.0 definitely works like a charm (at least in my Centos 6.5 instance here.)
Thanks for the time you took to assist with this.
Kind regards,
-----Original Message-----
From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
Sent: Wednesday,July 22, 2015 03:38 PM
To: Stefan Viljoen
Cc: pgsql-odbc(at)postgresql(dot)org; Devrim GÃœNDÃœZ
Subject: Re: [ODBC] Postgres 9.4 + unixODBC on Centos 6.5 problem connecting localhost postgres instance with isql ODBC commandline client - SOLVED
"Stefan Viljoen" <viljoens(at)verishare(dot)co(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Jean-Marc Guazzo | 2015-07-23 02:05:48 | Materialized Views |
Previous Message | Tom Lane | 2015-07-22 13:37:35 | Re: Postgres 9.4 + unixODBC on Centos 6.5 problem connecting localhost postgres instance with isql ODBC commandline client - SOLVED |