[unixODBC-support] UNRESOLVED: odbc driver manager and postgresql odbc driver in Ubuntu

ricardd at mathstat.dal.ca ricardd at mathstat.dal.ca
Wed Jun 14 20:37:04 BST 2006

Hello all,
Sorry for cross-posting but my problem involves both unixodbc and

Thanks for all the replies to earlier postings. However, I'm afraid to say
that nothing has been resolved after two days of attempts. While this may
be a routine task for the gurus, it is all pretty confusing for this

Could someone please paint a clear picture of what I need here? The basic
idea as far as I'm concerned:

1 - get postgresql up and running

2 - postgresql needs an odbc driver so that it can be accessible through ODBC

3 - get unixodbc up and running to enable ODBC on the system by using the
above driver to connect to postgresql

So I'm still at #2/#3. Here is what I don't understand:

1 - Is the postgresql driver procided by unixodbc appropriate or obsolete?
I don't really understand earlier replies on this (see below). The Ubuntu
packages "unixodbc-bin" and "unixodbc-dev" don't seem to include a
postgreSQL driver, but the latest source code does. So I removed the
packages and I'm now trying to build unixodbc from source. I get a build
error from "lex.l" and can't access a promising message on the mailing
list archive
I'm stuck.

2 - Is the Ubuntu package "odbc-postgresql" essentially the same as
building psqlodbc from source? If so, is this better than the unixodbc
postgresql driver? Also, how do I use this driver in unixodbc since it
doesn't have a "setup file"? Should I use iODBC instead of unixodbc?

3 - What is the "setup file" supposed to look like anyway? I'd be happy to
create it if I knew what it is supposed to be. Why is it so hard to find?
I have the postgresql people telling me that it isn't from them but I
couldn't  find it from the unixodbc-bin and unixodbc-dev packages either.

I had similar trouble setting this up last time and ended up leaving the
configuration to a sysadmin. It would be really good to be able to solve
this by myself this time around. I had odbc access to postgresql last week
before a forced reinstall. How I miss it now!

Apologies for my ignorance but rest assured that learning is taking place.


** earlier replies from pgsql-odbc at postgresql.org **

I can't say 2 different. unixodbc takes psqlodbc few years ago. So it has
obsolete psqlodbc driver. But they write theirs psqlodbcS.so which is only
for unixodbc settings purposes. That was I suggest in my previous message.
Ludek Finstrle

"Joshua D. Drake" <jd at commandprompt.com> writes:
> Tom Lane wrote:
>> There is a seriously obsolete postgres driver embedded in the unixodbc
source code.  Don't use that one :-(

> The Dapper unixODBC driver is: 08.01.0102

Oh?  unixODBC is at release 2.2.11 last I looked.

It could be that Ubuntu already pre-emptively nuked the old postgres
driver included with unixODBC --- which is something I have in mind to do
in the Red Hat release too ;-)
tom lane

** earlier reply from unixodbc-support at easysoft.com **

If you have the PG setup, it will be called libodbcpsqlS.so, you can 
always build the package from source to get the lib.
Nick Gorham
Easysoft Limited

More information about the unixODBC-support mailing list