Thread: compiling odbc

Brent Austin <brent1a@yahoo.com> writes:
> I am attempting to compile and install psqlodbc-08.03.0200 on my Mac Pro running Leopard.
> checking for pg_config... no
> configure: error: pg_config not found (set PG_CONFIG environment variable)

> How do I fix "configure: error: pg_config not found (set PG_CONFIG environment variable)"

Probably means you don't have Postgres itself installed.  On some
platforms it could mean that you don't have the postgresql-devel
subpackage installed, but I've not heard that anyone divides up the
package like that on OS X.

Another possibility is that PG is installed, but in a directory
that's not in your PATH.

            regards, tom lane

Brent Austin wrote:
> My pg_config file is in:  /usr/local/pgsql/bin  so how do I
> tell terminal to see that it's there instead of where it thinks it is?
>
> would this fix it:
>
> export PATH=$PATH:/usr/local/psql

Erm, no.
Try:

export PATH=$PATH:/usr/local/psql/bin

Yours,
Laurenz Albe

> So far this is what I get when I try that command-
>
> client-66-1xx-17-xx4:~ brent1a$ export PATH=$PATH:/usr/local/psql/bin
>
> client-66-1xx-17-xx4:~ brent1a$ cd /psqlodbc-08.03.0200
>
> client-66-1xx-17-xx4:psqlodbc-08.03.0200 brent1a$ sudo ./configure
>
[...]
>
> configure: error: pg_config not found (set PG_CONFIG environment variable)

Yeah, sure.

You should omit the "sudo", it's wrong.

But maybe it's best to follow the instructions you get and
export PG_CONFIG=/usr/local/psql/bin/pg_config

Yours,
Laurenz Albe

Hi,

Brent Austin wrote:
> My pg_config file is in:  /usr/local/pgsql/bin  so how do I
> tell terminal to see that it's there instead of where it thinks it is?
>
> would this fix it:
>
> export PATH=$PATH:/usr/local/psql

Could this be as simple as the 'g' being missing from the pgsql directory in the PATH?
i.e.
  export PATH=$PATH:/usr/local/psql
should be
  export PATH=$PATH:/usr/local/pgsql
and
  export PG_CONFIG=/usr/local/psql/bin/pg_config
should be
  export PG_CONFIG=/usr/local/pgsql/bin/pg_config

Regards,
Jeremy Faith


Albe Laurenz wrote:
>> So far this is what I get when I try that command-
>>
>> client-66-1xx-17-xx4:~ brent1a$ export PATH=$PATH:/usr/local/psql/bin
>>
>> client-66-1xx-17-xx4:~ brent1a$ cd /psqlodbc-08.03.0200
>>
>> client-66-1xx-17-xx4:psqlodbc-08.03.0200 brent1a$ sudo ./configure
>>
>>
> [...]
>
>> configure: error: pg_config not found (set PG_CONFIG environment variable)
>>
>
> Yeah, sure.
>
> You should omit the "sudo", it's wrong.
>
> But maybe it's best to follow the instructions you get and
> export PG_CONFIG=/usr/local/psql/bin/pg_config
>
> Yours,
> Laurenz Albe
>
>

Brent Austin <brent1a@yahoo.com> writes:
> How do I tell configure that pgsql is in /usr/local/pgsql and ALSO tell it that obcinst is in /opt/local/bin ???

Two PATH items?

            regards, tom lane

Hi,

I think what Tom is saying is to try:-
  PATH=$PATH:/usr/local/pgsql:/opt/local/bin

Regards,
Jeremy Faith

Brent Austin wrote:
> Yes, two PATH items, I guess.
> "export PATH=$PATH:/usr/local/pgsql"
>
> takes care of:
>
> "checking for pg_config... no
> configure: error: pg_config not found (set PG_CONFIG environment
> variable)"
>
> How can I take care of the following as well with out messing up the
> above?
>
> "configure: error: unixODBC library "odbcinst" not found"
>
> (I found "odbcinst" is in my /opt/local/bin)
>
> ----- Original Message ----
> From: Tom Lane <tgl@sss.pgh.pa.us>
> To: Brent Austin <brent1a@yahoo.com>
> Cc: Jeremy Faith <jfaith@cemsys.com>; pgsql-odbc@postgresql.org
> Sent: Friday, September 19, 2008 3:11:36 PM
> Subject: Re: [ODBC] compiling odbc
>
> Brent Austin <brent1a@yahoo.com <mailto:brent1a@yahoo.com>> writes:
> > How do I tell configure that pgsql is in /usr/local/pgsql and ALSO
> tell it that obcinst is in /opt/local/bin ???
>
> Two PATH items?
>
>             regards, tom lane
>

Brent Austin írta:
> I still get this:
> client-66-1xx-1x-x14:~ brent1a$
> PATH=$PATH:/usr/local/pgsql/bin:/opt/local/bin
> client-66-1xx-1x-x14:~ brent1a$ cd /psqlodbc-08.03.0200
> client-66-1xx-1x-x14:psqlodbc-08.03.0200 brent1a$ sudo ./configure
> checking for a BSD-compatible install... /usr/bin/install -c
> checking whether build environment is sane... yes
> checking for gawk... no
> checking for mawk... no
> checking for nawk... no
> checking for awk... awk
> checking whether make sets $(MAKE)... yes
> checking whether to enable maintainer-specific portions of Makefiles... no
> checking for pg_config... /usr/local/pgsql/bin/pg_config
> checking for gcc... gcc
> ...........
> checking how to hardcode library paths into programs... immediate
> checking for library containing SQLGetPrivateProfileString... no
> *configure: error: unixODBC library "odbcinst" not found*
> client-66-1xx-1x-x14:psqlodbc-08.03.0200 brent1a$

You need unixODBC or iODBC installed. unixODBC is used by default,
you can change the expected ODBC manager with option --with-iodbc.

> ----- Original Message ----
> From: Jeremy Faith <jfaith@cemsys.com>
> To: pgsql-odbc@postgresql.org
> Sent: Monday, September 22, 2008 4:06:28 AM
> Subject: Re: [ODBC] compiling odbc
>
> Hi,
>
> I think what Tom is saying is to try:-
>   PATH=$PATH:/usr/local/pgsql:/opt/local/bin
>
> Regards,
> Jeremy Faith
>
> Brent Austin wrote:
> > Yes, two PATH items, I guess.
> > "export PATH=$PATH:/usr/local/pgsql"
> >
> > takes care of:
> >
> > "checking for pg_config... no
> > configure: error: pg_config not found (set PG_CONFIG environment
> > variable)"
> >
> > How can I take care of the following as well with out messing up the
> > above?
> >
> > "configure: error: unixODBC library "odbcinst" not found"
> >
> > (I found "odbcinst" is in my /opt/local/bin)
> >
> > ----- Original Message ----
> > From: Tom Lane <tgl@sss.pgh.pa.us <mailto:tgl@sss.pgh.pa.us>>
> > To: Brent Austin <brent1a@yahoo.com <mailto:brent1a@yahoo.com>>
> > Cc: Jeremy Faith <jfaith@cemsys.com <mailto:jfaith@cemsys.com>>;
> pgsql-odbc@postgresql.org <mailto:pgsql-odbc@postgresql.org>
> > Sent: Friday, September 19, 2008 3:11:36 PM
> > Subject: Re: [ODBC] compiling odbc
> >
> > Brent Austin <brent1a@yahoo.com <mailto:brent1a@yahoo.com>
> <mailto:brent1a@yahoo.com <mailto:brent1a@yahoo.com>>> writes:
> > > How do I tell configure that pgsql is in /usr/local/pgsql and ALSO
> > tell it that obcinst is in /opt/local/bin ???
> >
> > Two PATH items?
> >
> >            regards, tom lane
> >
>
>
> --
> Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org
> <mailto:pgsql-odbc@postgresql.org>)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-odbc
>


--
----------------------------------
Zoltán Böszörményi
Cybertec Schönig & Schönig GmbH
http://www.postgresql.at/

Brent Austin wrote:
> That's the thing, I have unixODBC installed, it is located
> at /opt/local/bin that is why I need help figuring out how to get the
> terminal to recognize where both pg_config AND obdcinst are at during
> the ./configure process.
> PATH=$PATH:/usr/local/pgsql/bin:/opt/local/bin   should work but it's
> not recognizing the second part.....the odncinst part.

Try something like

export LDFLAGS=-L/opt/local/lib

> Brent Austin wrote:
>> That's the thing, I have unixODBC installed, it is located
>> at /opt/local/bin that is why I need help figuring out how to get the
>> terminal to recognize where both pg_config AND obdcinst are at during
>> the ./configure process.
>> PATH=$PATH:/usr/local/pgsql/bin:/opt/local/bin   should work but it's
>> not recognizing the second part.....the odncinst part.
>
> Try something like
>
> export LDFLAGS=-L/opt/local/lib

Yeah, or they must be found odbc_config(unixODBC) by configure.

unixODBC is this
hiroshi@developer:~$ which odbc_config
/usr/local/bin/odbc_config
hiroshi@developer:~$ odbc_config --libs
-L/usr/local/lib -lodbc

iODBC is this.
inet% which iodbc-config
/usr/local/bin/iodbc-config
inet% iodbc-config --libs
-L/usr/local/lib  -liodbc -liodbcinst

Brent-san, are they found from your path?

Regards,
Hiroshi Saito