Thread: Compiling psqlodbc on Solaris

Compiling psqlodbc on Solaris

From
Nishad Prakash
Date:

I'm trying to install the postgres ODBC driver but I can't understand
the installation instructions.  My platform is PostgreSQL 7.4.6 on
sparc-sun-solaris2.8, compiled by GCC gcc (GCC) 3.3.  I'm using
psqlodbc-7.2.5; I don't quite get how the psqlodbc numbering is meant
to correspond to Postgres versions, so if I'm using the wrong
version, please let me know.

The instructions say I must unzip the psqlodbc tarball, then go to the
Postgres src directory and run configure-make-install.  Well, how,
exactly?  Is this telling me to rebuild Postgres with the psqlodbc
directories included under the main Postgres source tree?  I already
have a running Postgres installation; I simply want to add the odbc
driver.  Can I do that?  If so, how do I compile the psqlodbc source
without recompiling all of Postgres?  Any help would be tremendously
appreciated.

nishad
--
"Underneath the concrete, the dream is still alive" -- Talking Heads


Re: Compiling psqlodbc on Solaris

From
"Dave Page"
Date:

> -----Original Message-----
> From: pgsql-odbc-owner@postgresql.org
> [mailto:pgsql-odbc-owner@postgresql.org] On Behalf Of Nishad Prakash
> Sent: 24 March 2005 20:19
> To: pgsql-odbc@postgresql.org
> Subject: [ODBC] Compiling psqlodbc on Solaris
>
>
>
> I'm trying to install the postgres ODBC driver but I can't understand
> the installation instructions.  My platform is PostgreSQL 7.4.6 on
> sparc-sun-solaris2.8, compiled by GCC gcc (GCC) 3.3.  I'm using
> psqlodbc-7.2.5; I don't quite get how the psqlodbc numbering is meant
> to correspond to Postgres versions, so if I'm using the wrong
> version, please let me know.

They vaguely correspond to the current release version at the time
they're built, however the current driver should work with much earlier
versions of PostgreSQL (in theory, back to 6.2).

> The instructions say I must unzip the psqlodbc tarball, then go to the
> Postgres src directory and run configure-make-install.  Well, how,
> exactly?  Is this telling me to rebuild Postgres with the psqlodbc
> directories included under the main Postgres source tree?  I already
> have a running Postgres installation; I simply want to add the odbc
> driver.  Can I do that?  If so, how do I compile the psqlodbc source
> without recompiling all of Postgres?  Any help would be tremendously
> appreciated.

# tar -zvxf psqlodbc-08.00.0101.tar.gz
# cd psqlodbc-08.00.0101
# ./configure     (you might need to add --with-iodbc or --with-unixodbc
here)
# make
# make install

You only need a PostgreSQL tree to build your own tarball from the CVS
source.

Regards, Dave.