compiling odbc

--0-592471986-1221761415=:40504
Content-Type: text/plain; charset=us-ascii

I am attempting to compile and install psqlodbc-08.03.0200 on my Mac Pro running Leopard.
Here is what I get:
client-66-xxx-17-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... 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)"
(I'm relatively new to most of this?
thanks
-B

--0-592471986-1221761415=:40504
Content-Type: text/html; charset=us-ascii

<html><head><style type="text/css"></style></head><body><div style="font-family:arial, helvetica, sans-serif;font-size:8pt"><div><font class="Apple-style-span" face="arial, helvetica, sans-serif"><span class="Apple-style-span" style="font-size: small;">I am attempting to compile and install </span></font><font class="Apple-style-span" face="arial, helvetica, sans-serif"><span class="Apple-style-span" style="font-size: small;">psqlodbc-08.03.0200 on my Mac Pro running Leopard.</span></font></div><div><font class="Apple-style-span" face="arial, helvetica, sans-serif"><span class="Apple-style-span" style="font-size: small;">Here is what I get:</span></font></div><div><font class="Apple-style-span" face="'Lucida Grande'" size="3"><span class="Apple-style-span" st
yle="font-size: 12px;"><div><font class="Apple-style-span" face="arial, helvetica, sans-serif"><span class="Apple-style-span" style="font-size:
small;">client-66-xxx-17-x14:psqlodbc-08.03.0200 brent1a$ sudo ./configure</span></font></div><div><font class="Apple-style-span" face="arial, helvetica, sans-serif"><span class="Apple-style-span" style="font-size: small;">checking for a BSD-compatible install... /usr/bin/install -c</span></font></div><div><font class="Apple-style-span" face="arial, helvetica, sans-serif"><span class="Apple-style-span" style="font-size: small;">checking whether build environment is sane... yes</span></font></div><div><font class="Apple-style-span" face="arial, helvetica, sans-serif"><span class="Apple-style-span" style="font-size: small;">checking for gawk... no</span></font></div><div><font class="Apple-style-span" face="arial, helvetica, sans-serif"><span class="Apple-style-span" style="font-size: small
;">checking for mawk... no</span></font></div><div><font class="Apple-style-span" face="arial, helvetica, sans-serif"><span class="Apple-style-span" style="font-size:
small;">checking for nawk... no</span></font></div><div><font class="Apple-style-span" face="arial, helvetica, sans-serif"><span class="Apple-style-span" style="font-size: small;">checking for awk... awk</span></font></div><div><font class="Apple-style-span" face="arial, helvetica, sans-serif"><span class="Apple-style-span" style="font-size: small;">checking whether make sets $(MAKE)... yes</span></font></div><div><font class="Apple-style-span" face="arial, helvetica, sans-serif"><span class="Apple-style-span" style="font-size: small;">checking whether to enable maintainer-specific portions of Makefiles... no</span></font></div><div><font class="Apple-style-span" face="arial, helvetica, sans-serif"><span class="Apple-style-span" style="font-size: small;">checking for pg_config... no</span
></font></div><div><font class="Apple-style-span" face="arial, helvetica, sans-serif"><span class="Apple-style-span" style="font-size: small;">configure: error:
pg_config not found (set PG_CONFIG environment variable)</span></font></div><div><font class="Apple-style-span" face="arial, helvetica, sans-serif"><span class="Apple-style-span" style="font-size: small;"><br></span></font></div><div><font class="Apple-style-span" face="arial, helvetica, sans-serif"><span class="Apple-style-span" style="font-size: small;">How do I fix "configure: error: pg_config not found (set PG_CONFIG environment variable)"</span></font></div><div><font class="Apple-style-span" face="arial, helvetica, sans-serif"><span class="Apple-style-span" style="font-size: small;">(I'm relatively new to most of this?</span></font></div><div><font class="Apple-style-span" face="arial, helvetica, sans-serif"><span class="Apple-style-span" style="font-size: small;">thanks</span></fon
t></div><div><font class="Apple-style-span" face="arial, helvetica, sans-serif"><span class="Apple-style-span" style="font-size:
small;">-B</span></font></div></span></font></div><div style="position:fixed"></div></div><br>

</body></html>
--0-592471986-1221761415=:40504--

Brent Austin [ Do, 18 September 2008 20:10 ] [ ID #1969509 ]

Re: compiling odbc

Brent Austin <brent1a [at] 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

--
Sent via pgsql-odbc mailing list (pgsql-odbc [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc

Tom Lane [ Do, 18 September 2008 20:52 ] [ ID #1969510 ]

Re: compiling odbc

--0-1630071379-1221765307=:65557
Content-Type: text/plain; charset=us-ascii

I just installed the latest Postgres from source so everything needed should be there. Some of the things I've been installing recently have not had the right PATH but I thought I fixed that. What would fix this problem?
I think postgres is installed in:
/usr/local/psql

would this fix it:
export PATH=$PATH:/usr/local/psql
or maybe
echo "export PATH=\"/usr/local/psql:$PATH\"" >>.bash_profile

----- Original Message ----
From: Tom Lane <tgl [at] sss.pgh.pa.us>
To: Brent Austin <brent1a [at] yahoo.com>
Cc: pgsql-odbc [at] postgresql.org
Sent: Thursday, September 18, 2008 1:52:00 PM
Subject: Re: [ODBC] compiling odbc

Brent Austin <brent1a [at] 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

--0-1630071379-1221765307=:65557
Content-Type: text/html; charset=us-ascii

<html><head><style type="text/css"></style></head><body><div style="font-family:arial, helvetica, sans-serif;font-size:10pt"><div><font class="Apple-style-span" face="'times new roman'" size="4"><span class="Apple-style-span" style="font-size: 16px;"><br></span></font></div><div style="font-family:arial, helvetica, sans-serif;font-size:10pt"><div style="font-family:times new roman, new york, times, serif;font-size:12pt">
<div style="font-family:arial, helvetica, sans-serif;font-size:10pt;"><div><span class="Apple-style-span" style="font-size:small;"><font class="Apple-style-span" face="arial, helvetica, sans-serif">I just installed the latest Postgres from source so everything needed should be there. Some of the things I've been installing recently have not had the right PATH but I thought I fixed that. What would fix this problem?</font></span></div><div><span class="Apple-style-span" style="font-size:small;"><font class="Apple-style-span" face="arial, helvetica, sans-serif">I think postgres is installed in:</font></span></div><div><span class="Apple-style-span" style="font-size:small;"><font class="Apple-style-span" face="arial, helvetica, sans-serif">/usr/local/psql</font></span></div><div><span class="
Apple-style-span" style="font-size:small;"><font class="Apple-style-span" face="arial, helvetica, sans-serif"><br></font></span></div><div style=""><span
class="Apple-style-span" style="font-size:small;"><font class="Apple-style-span" face="arial, helvetica, sans-serif">would this fix it:</font></span></div><div style=""><p style="margin:0.0px 0.0px 0.0px 0.0px;font:16.0px Times New Roman;"><span class="Apple-style-span" style="font-size:small;"><font class="Apple-style-span" face="arial, helvetica, sans-serif">export PATH=$PATH:/usr/local/psql</font></span></p><p style="margin:0.0px 0.0px 0.0px 0.0px;font:16.0px Times New Roman;"><span class="Apple-style-span" style="font-size:small;"><font class="Apple-style-span" face="arial, helvetica, sans-serif">or maybe</font></span></p><p style="margin:0.0px 0.0px 0.0px 0.0px;font:16.0px Times New Roman;"></p><p style="margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0px;line-height:16
px;font:normal normal normal 12px/normal 'Lucida Grande';"><span class="Apple-style-span" style="font-size:small;"><font class="Apple-style-span" face="arial,
helvetica, sans-serif">echo "export PATH=\"/usr/local/psql:$PATH\"" </font></span><span class="Apple-style-span" style="font-size:small;"><font class="Apple-style-span" face="arial, helvetica, sans-serif">>></font></span><span class="Apple-style-span" style="font-size:small;"><font class="Apple-style-span" face="arial, helvetica, sans-serif"> .bash_profile</font></span></p></div><div style="font-family:arial, helvetica, sans-serif;font-size:10pt;"><br><div style="font-family:arial, helvetica, sans-serif;font-size:13px;">----- Original Message ----<br>From: Tom Lane <tgl [at] sss.pgh.pa.us><br>To: Brent Austin <brent1a [at] yahoo.com><br>Cc: pgsql-odbc [at] postgresql.org<br>Sent: Thursday, September 18, 2008 1:52:00 PM<br>Subject: Re: [ODBC] compiling odbc <br><br>
Brent Austin <<a rel="nofollow" ymailto="mailto:brent1a [at] yahoo.com" target="_blank" href="mailto:brent1a [at] yahoo.com">brent1a [at] yahoo.com</a>> writes:<br>> I am attempting to compile and install psqlodbc-08.03.0200 on my Mac Pro running Leopard.<br>> checking for pg_config... no<br>> configure: error: pg_config not found (set PG_CONFIG environment variable)<br><br>> How do I fix "configure: error: pg_config not found (set PG_CONFIG environment variable)"<br><br>Probably means you don't have Postgres itself installed. On some<br>platforms it could mean that you don't have the postgresql-devel<br>subpackage installed, but I've not heard that anyone divides up the<br>package like that on OS X.<br><br>Another possibility is that PG is installed, but in a directory<br>that's
not in your PATH.<br><br> regards, tom lane<br></div></div><div style=""></div></div><br>

</div></div><div style="position:fixed"></div></div><br>

</body></html>
--0-1630071379-1221765307=:65557--

Brent Austin [ Do, 18 September 2008 21:15 ] [ ID #1969511 ]

Re: compiling odbc

--0-1595947859-1221765533=:79132
Content-Type: text/plain; charset=us-ascii

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?

----- Original Message ----
From: Brent Austin <brent1a [at] yahoo.com>
To: pgsql-odbc [at] postgresql.org
Sent: Thursday, September 18, 2008 2:15:07 PM
Subject: Re: [ODBC] compiling odbc

I just installed the latest Postgres from source so everything needed should be there. Some of the things I've been installing recently have not had the right PATH but I thought I fixed that. What would fix this problem?
I think postgres is installed in:
/usr/local/psql

would this fix it:
export PATH=$PATH:/usr/local/psql
or maybe
echo "export PATH=\"/usr/local/psql:$PATH\"" >>.bash_profile

----- Original Message ----
From: Tom Lane <tgl [at] sss.pgh.pa.us>
To: Brent Austin <brent1a [at] yahoo.com>
Cc: pgsql-odbc [at] postgresql.org
Sent: Thursday, September 18, 2008 1:52:00 PM
Subject: Re: [ODBC] compiling odbc

Brent Austin <brent1a [at] 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

--0-1595947859-1221765533=:79132
Content-Type: text/html; charset=us-ascii

<html><head><style type="text/css"></style></head><body><div style="font-family:arial, helvetica, sans-serif;font-size:10pt"><div>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?</div><div><br></div><div style="font-family:arial, helvetica, sans-serif;font-size:10pt"><br><div style="font-family:times new roman, new york, times, serif;font-size:12pt">----- Original Message ----<br>From: Brent Austin <brent1a [at] yahoo.com><br>To: pgsql-odbc [at] postgresql.org<br>Sent: Thursday, September 18, 2008 2:15:07 PM<br>Subject: Re: [ODBC] compiling odbc<br><br>
<div style="font-family:arial, helvetica, sans-serif;font-size:10pt;"><div><font class="Apple-style-span" face="'times new roman'" size="4"><span class="Apple-style-span" style="font-size:16px;"><br></span></font></div><div style="font-family:arial, helvetica, sans-serif;font-size:10pt;"><div style="font-family:times new roman, new york, times, serif;font-size:12pt;">
<div style="font-family:arial, helvetica, sans-serif;font-size:10pt;"><div><span class="Apple-style-span" style="font-size:small;"><font class="Apple-style-span" face="arial, helvetica, sans-serif">I just installed the latest Postgres from source so everything needed should be there. Some of the things I've been installing recently have not had the right PATH but I thought I fixed that. What would fix this problem?</font></span></div><div><span class="Apple-style-span" style="font-size:small;"><font class="Apple-style-span" face="arial, helvetica, sans-serif">I think postgres is installed in:</font></span></div><div><span class="Apple-style-span" style="font-size:small;"><font class="Apple-style-span" face="arial, helvetica, sans-serif">/usr/local/psql</font></span></div><div><span class="
Apple-style-span" style="font-size:small;"><font class="Apple-style-span" face="arial, helvetica, sans-serif"><br></font></span></div><div style=""><span
class="Apple-style-span" style="font-size:small;"><font class="Apple-style-span" face="arial, helvetica, sans-serif">would this fix it:</font></span></div><div style=""><p style="margin:0.0px 0.0px 0.0px 0.0px;font:16.0px Times New Roman;"><span class="Apple-style-span" style="font-size:small;"><font class="Apple-style-span" face="arial, helvetica, sans-serif">export PATH=$PATH:/usr/local/psql</font></span></p><p style="margin:0.0px 0.0px 0.0px 0.0px;font:16.0px Times New Roman;"><span class="Apple-style-span" style="font-size:small;"><font class="Apple-style-span" face="arial, helvetica, sans-serif">or maybe</font></span></p><p style="margin:0.0px 0.0px 0.0px 0.0px;font:16.0px Times New Roman;"></p><p style="margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0px;line-height:16
px;font:normal normal normal 12px/normal 'Lucida Grande';"><span class="Apple-style-span" style="font-size:small;"><font class="Apple-style-span" face="arial,
helvetica, sans-serif">echo "export PATH=\"/usr/local/psql:$PATH\"" </font></span><span class="Apple-style-span" style="font-size:small;"><font class="Apple-style-span" face="arial, helvetica, sans-serif">>></font></span><span class="Apple-style-span" style="font-size:small;"><font class="Apple-style-span" face="arial, helvetica, sans-serif"> .bash_profile</font></span></p></div><div style="font-family:arial, helvetica, sans-serif;font-size:10pt;"><br><div style="font-family:arial, helvetica, sans-serif;font-size:13px;">----- Original Message ----<br>From: Tom Lane <tgl [at] sss.pgh.pa.us><br>To: Brent Austin <brent1a [at] yahoo.com><br>Cc: pgsql-odbc [at] postgresql.org<br>Sent: Thursday, September 18, 2008 1:52:00 PM<br>Subject: Re: [ODBC] compiling odbc <br><br>
Brent Austin <<a rel="nofollow" ymailto="mailto:brent1a [at] yahoo.com" target="_blank" href="mailto:brent1a [at] yahoo.com">brent1a [at] yahoo.com</a>> writes:<br>> I am attempting to compile and install psqlodbc-08.03.0200 on my Mac Pro running Leopard.<br>> checking for pg_config... no<br>> configure: error: pg_config not found (set PG_CONFIG environment variable)<br><br>> How do I fix "configure: error: pg_config not found (set PG_CONFIG environment variable)"<br><br>Probably means you don't have Postgres itself installed. On some<br>platforms it could mean that you don't have the postgresql-devel<br>subpackage installed, but I've not heard that anyone divides up the<br>package like that on OS X.<br><br>Another possibility is that PG is installed, but in a directory<br>that's
not in your PATH.<br><br> regards, tom lane<br></div></div><div style=""></div></div><br>

</div></div><div style=""></div></div><br>

</div></div><div style="position:fixed"></div></div><br>

</body></html>
--0-1595947859-1221765533=:79132--

Brent Austin [ Do, 18 September 2008 21:18 ] [ ID #1969512 ]

Re: compiling odbc

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=3D$PATH:/usr/local/psql

Erm, no.
Try:

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

Yours,
Laurenz Albe

--
Sent via pgsql-odbc mailing list (pgsql-odbc [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc

Albe Laurenz [ Fr, 19 September 2008 08:35 ] [ ID #1969644 ]

Re: compiling odbc

--0-55704902-1221813199=:10875
Content-Type: text/plain; charset=us-ascii

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
Password:
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... no
configure: error: pg_config not found (set PG_CONFIG environment variable)
client-66-1xx-17-xx4:psqlodbc-08.03.0200 brent1a$

----- Original Message ----
From: Albe Laurenz <laurenz.albe [at] wien.gv.at>
To: Brent Austin *EXTERN* <brent1a [at] yahoo.com>; pgsql-odbc [at] postgresql.org
Sent: Friday, September 19, 2008 1:35:20 AM
Subject: RE: [ODBC] compiling odbc

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

--0-55704902-1221813199=:10875
Content-Type: text/html; charset=us-ascii

<html><head><style type="text/css"></style></head><body><div style="font-family:arial, helvetica, sans-serif;font-size:10pt"><div>So far this is what I get when I try that command-</div><div><br></div><div><p style="margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px Helvetica">client-66-1xx-17-xx4:~ brent1a$ export PATH=$PATH:/usr/local/psql/bin</p>
<p style="margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px Helvetica">client-66-1xx-17-xx4:~ brent1a$ cd /psqlodbc-08.03.0200 </p>
<p style="margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px Helvetica">client-66-1xx-17-xx4:psqlodbc-08.03.0200 brent1a$ sudo ./configure</p>
<p style="margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px Helvetica">Password:</p>
<p style="margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px Helvetica">checking for a BSD-compatible install... /usr/bin/install -c</p>
<p style="margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px Helvetica">checking whether build environment is sane... yes</p>
<p style="margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px Helvetica">checking for gawk... no</p>
<p style="margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px Helvetica">checking for mawk... no</p>
<p style="margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px Helvetica">checking for nawk... no</p>
<p style="margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px Helvetica">checking for awk... awk</p>
<p style="margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px Helvetica">checking whether make sets $(MAKE)... yes</p>
<p style="margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px Helvetica">checking whether to enable maintainer-specific portions of Makefiles... no</p>
<p style="margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px Helvetica">checking for pg_config... no</p>
<p style="margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px Helvetica">configure: error: pg_config not found (set PG_CONFIG environment variable)</p>
<p style="margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px Helvetica">client-66-1xx-17-xx4:psqlodbc-08.03.0200 brent1a$ </p></div><div style="font-family:arial, helvetica, sans-serif;font-size:10pt"><br><div style="font-family:arial, helvetica, sans-serif;font-size:13px">----- Original Message ----<br>From: Albe Laurenz <laurenz.albe [at] wien.gv.at><br>To: Brent Austin *EXTERN* <brent1a [at] yahoo.com>; pgsql-odbc [at] postgresql.org<br>Sent: Friday, September 19, 2008 1:35:20 AM<br>Subject: RE: [ODBC] compiling odbc<br><br>
Brent Austin wrote:<br>> My pg_config file is in: /usr/local/pgsql/bin so how do I <br>> tell terminal to see that it's there instead of where it thinks it is?<br>> <br>> would this fix it:<br>> <br>> export PATH=$PATH:/usr/local/psql<br><br>Erm, no.<br>Try:<br><br>export PATH=$PATH:/usr/local/psql/bin<br><br>Yours,<br>Laurenz Albe<br></div></div><div style="position:fixed"></div></div><br>

</body></html>
--0-55704902-1221813199=:10875--

Brent Austin [ Fr, 19 September 2008 10:33 ] [ ID #1969645 ]

Re: compiling odbc

> So far this is what I get when I try that command-
>
> client-66-1xx-17-xx4:~ brent1a$ export PATH=3D$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=3D/usr/local/psql/bin/pg_config

Yours,
Laurenz Albe

--
Sent via pgsql-odbc mailing list (pgsql-odbc [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc

Albe Laurenz [ Fr, 19 September 2008 13:11 ] [ ID #1969646 ]

Re: compiling odbc

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
>
>

--
Sent via pgsql-odbc mailing list (pgsql-odbc [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc

Jeremy Faith [ Fr, 19 September 2008 13:35 ] [ ID #1969647 ]

Re: compiling odbc

--0-524070078-1221848731=:1781
Content-Type: text/plain; charset=us-ascii

I got export PATH=$PATH:/usr/local/pgsql to work

but now I get:
"configure: error: unixODBC library "odbcinst" not found"

I found that "odbcinst" is in my /opt/local/bin

How do I tell configure that pgsql is in /usr/local/pgsql and ALSO tell it that obcinst is in /opt/local/bin ???

----- Original Message ----
From: Jeremy Faith <jfaith [at] cemsys.com>
To: pgsql-odbc [at] postgresql.org
Sent: Friday, September 19, 2008 6:35:23 AM
Subject: Re: [ODBC] compiling odbc

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
>
>

--
Sent via pgsql-odbc mailing list (pgsql-odbc [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc

--0-524070078-1221848731=:1781
Content-Type: text/html; charset=us-ascii

<html><head><style type="text/css"></style></head><body><div style="font-family:arial, helvetica, sans-serif;font-size:10pt"><div>I got export PATH=$PATH:/usr/local/pgsql to work</div><div><br></div><div>but now I get:</div><div>"configure: error: unixODBC library "odbcinst" not found"</div><div><br></div><div>I found that "odbcinst" is in my /opt/local/bin</div><div><br></div><div>How do I tell configure that pgsql is in /usr/local/pgsql and ALSO tell it that obcinst is in /opt/local/bin ???</div><div><br></div><div><br></div><div><br></div><div style="font-family:arial, helvetica, sans-serif;font-size:10pt"><br><div style="font-family:arial, helvetica, sans-serif;font-size:13px">----- Original Message ----<br>From: Jeremy Faith <jfaith [at] cemsys.com><br>
To: pgsql-odbc [at] postgresql.org<br>Sent: Friday, September 19, 2008 6:35:23 AM<br>Subject: Re: [ODBC] compiling odbc<br><br>
Hi,<br><br>Brent Austin wrote:<br>> My pg_config file is in: /usr/local/pgsql/bin so how do I <br>> tell terminal to see that it's there instead of where it thinks it is?<br>> <br>> would this fix it:<br>> <br>> export PATH=$PATH:/usr/local/psql<br><br>Could this be as simple as the 'g' being missing from the pgsql directory in the PATH?<br>i.e.<br> export PATH=$PATH:/usr/local/psql<br>should be<br> export PATH=$PATH:/usr/local/pgsql<br>and<br> export PG_CONFIG=/usr/local/psql/bin/pg_config<br>should be<br> export PG_CONFIG=/usr/local/pgsql/bin/pg_config<br><br>Regards,<br>Jeremy Faith<br><br><br>Albe Laurenz wrote:<br>>> So far this is what I get when I try that command-<br>>><br>>> client-66-1xx-17-xx4:~ brent1a$ exp
ort PATH=$PATH:/usr/local/psql/bin<br>>><br>>> client-66-1xx-17-xx4:~ brent1a$ cd /psqlodbc-08.03.0200 <br>>><br>>>
client-66-1xx-17-xx4:psqlodbc-08.03.0200 brent1a$ sudo ./configure<br>>><br>>> <br>> [...]<br>> <br>>> configure: error: pg_config not found (set PG_CONFIG environment variable)<br>>> <br>><br>> Yeah, sure.<br>><br>> You should omit the "sudo", it's wrong.<br>><br>> But maybe it's best to follow the instructions you get and<br>> export PG_CONFIG=/usr/local/psql/bin/pg_config<br>><br>> Yours,<br>> Laurenz Albe<br>><br>> <br><br><br>-- <br>Sent via pgsql-odbc mailing list (<a ymailto="mailto:pgsql-odbc [at] postgresql.org" href="mailto:pgsql-odbc [at] postgresql.org">pgsql-odbc [at] postgresql.org</a>)<br>To make changes to your subscription:<br><a href="http://www.postgresql.org/mailpref/pgsql-odbc
" target="_blank">http://www.postgresql.org/mailpref/pgsql-odb c</a><br></div></div><div style="position:fixed"></div></div><br>

</body></html>
--0-524070078-1221848731=:1781--

Brent Austin [ Fr, 19 September 2008 20:25 ] [ ID #1969648 ]

Re: compiling odbc

Brent Austin <brent1a [at] 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 [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc

Tom Lane [ Fr, 19 September 2008 22:11 ] [ ID #1969649 ]

Re: compiling odbc

--0-635509740-1221864556=:15314
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

Yes, two PATH items, I guess.=0A"export PATH=3D$PATH:/usr/local/pgsql"=0A=
=A0=0Atakes care of:=0A=A0=0A"checking for pg_config... no=0Aconfigure: err=
or: pg_config not found (set PG_CONFIG environment variable)"=0A=A0=0AHow c=
an I take care of the following as well with out messing up the above? =0A=
=0A=0A"configure: error: unixODBC library "odbcinst" not found"=0A=0A(I fou=
nd=A0"odbcinst" is in my /opt/local/bin)=0A=0A=0A----- Original Message ---=
-=0AFrom: Tom Lane <tgl [at] sss.pgh.pa.us>=0ATo: Brent Austin <brent1a [at] yahoo.co=
m>=0ACc: Jeremy Faith <jfaith [at] cemsys.com>; pgsql-odbc [at] postgresql.org=0ASent=
: Friday, September 19, 2008 3:11:36 PM=0ASubject: Re: [ODBC] compiling odb=
c=0A=0ABrent Austin <brent1a [at] yahoo.com> writes:=0A> How do I tell configure=
that pgsql is in /usr/local/pgsql and ALSO tell it that obcinst is in /opt=
/local/bin ???=0A=0ATwo PATH items?=0A=0A=A0=A0=A0 =A0=A0=A0 =A0=A0=A0 rega=
rds, tom lane=0A=0A=0A=0A
--0-635509740-1221864556=:15314
Content-Type: text/html; charset=us-ascii

<html><head><style type="text/css"></style></head><body><div style="font-family:arial, helvetica, sans-serif;font-size:14pt"><DIV>
<DIV><FONT class=Apple-style-span face="arial, helvetica, sans-serif"><SPAN class=Apple-style-span style="FONT-SIZE: small">Yes, two PATH items, I guess.</SPAN></FONT></DIV>
<DIV><FONT class=Apple-style-span face="arial, helvetica, sans-serif"><SPAN class=Apple-style-span style="FONT-SIZE: small">"export PATH=$PATH:/usr/local/pgsql"</SPAN></FONT></DIV>
<DIV><FONT class=Apple-style-span face="arial, helvetica, sans-serif" size=3><SPAN class=Apple-style-span style="FONT-SIZE: small"></SPAN></FONT> </DIV>
<DIV><FONT class=Apple-style-span face="arial, helvetica, sans-serif"><SPAN class=Apple-style-span style="FONT-SIZE: small">takes care of:</SPAN></FONT></DIV>
<DIV><FONT class=Apple-style-span face="arial, helvetica, sans-serif" size=3><SPAN class=Apple-style-span style="FONT-SIZE: small"></SPAN></FONT> </DIV>
<DIV><FONT class=Apple-style-span face="arial, helvetica, sans-serif"><SPAN class=Apple-style-span style="FONT-SIZE: small">"checking for pg_config... no</SPAN></FONT></DIV>
<DIV><FONT class=Apple-style-span face="arial, helvetica, sans-serif"><SPAN class=Apple-style-span style="FONT-SIZE: small">configure: error: pg_config not found (set PG_CONFIG <SPAN class=yshortcuts id=lw_1221864244_1 style="BACKGROUND: #dceeff; CURSOR: hand; BORDER-BOTTOM: #0066cc 1px dashed">environment variable</SPAN>)"</SPAN></FONT></DIV>
<DIV><FONT class=Apple-style-span face="arial, helvetica, sans-serif" size=3><SPAN class=Apple-style-span style="FONT-SIZE: small"></SPAN></FONT> </DIV><FONT class=Apple-style-span face="arial, helvetica, sans-serif"><SPAN class=Apple-style-span style="FONT-SIZE: small"></SPAN></FONT></DIV>
<DIV><FONT class=Apple-style-span face="arial, helvetica, sans-serif"><SPAN class=Apple-style-span style="FONT-SIZE: small">How can I take care of the following as well with out messing up the above?</SPAN></FONT>
<DIV><BR>
<DIV><FONT size=3>"configure: error: unixODBC library "odbcinst" not found"</FONT></DIV>
<DIV><FONT size=3><BR></FONT></DIV>
<DIV><FONT size=3>(I found "odbcinst" is in my /opt/local/bin)</FONT></DIV></DIV></DIV>
<DIV style="FONT-SIZE: 14pt; FONT-FAMILY: arial, helvetica, sans-serif"><BR>
<DIV style="FONT-SIZE: 13px; FONT-FAMILY: arial, helvetica, sans-serif">----- Original Message ----<BR>From: Tom Lane <tgl [at] sss.pgh.pa.us><BR>To: Brent Austin <brent1a [at] yahoo.com><BR>Cc: Jeremy Faith <jfaith [at] cemsys.com>; pgsql-odbc [at] postgresql.org<BR>Sent: Friday, September 19, 2008 3:11:36 PM<BR>Subject: Re: [ODBC] compiling odbc<BR><BR>Brent Austin <<A href="mailto:brent1a [at] yahoo.com" ymailto="mailto:brent1a [at] yahoo.com">brent1a [at] yahoo.com</A>> writes:<BR>> How do I tell configure that pgsql is in /usr/local/pgsql and ALSO tell it that obcinst is in /opt/local/bin ???<BR><BR>Two PATH items?<BR><BR> regards, tom lane<BR></DIV></DIV></div><br>

</body></html>
--0-635509740-1221864556=:15314--

Brent Austin [ Sa, 20 September 2008 00:49 ] [ ID #1969714 ]

Re: 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 [at] sss.pgh.pa.us>
> To: Brent Austin <brent1a [at] yahoo.com>
> Cc: Jeremy Faith <jfaith [at] cemsys.com>; pgsql-odbc [at] postgresql.org
> Sent: Friday, September 19, 2008 3:11:36 PM
> Subject: Re: [ODBC] compiling odbc
>
> Brent Austin <brent1a [at] yahoo.com <mailto:brent1a [at] 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 [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc

Jeremy Faith [ Mo, 22 September 2008 11:06 ] [ ID #1969991 ]

Re: compiling odbc

--0-1039446695-1222077683=:64809
Content-Type: text/plain; charset=us-ascii

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$

----- Original Message ----
From: Jeremy Faith <jfaith [at] cemsys.com>
To: pgsql-odbc [at] 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 [at] sss.pgh.pa.us>
> To: Brent Austin <brent1a [at] yahoo.com>
> Cc: Jeremy Faith <jfaith [at] cemsys.com>; pgsql-odbc [at] postgresql.org
> Sent: Friday, September 19, 2008 3:11:36 PM
> Subject: Re: [ODBC] compiling odbc
>
> Brent Austin <brent1a [at] yahoo.com <mailto:brent1a [at] 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 [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc

--0-1039446695-1222077683=:64809
Content-Type: text/html; charset=us-ascii

<html><head><style type="text/css"></style></head><body><div style="font-family:arial, helvetica, sans-serif;font-size:12pt"><div>I still get this:</div><div><div><div>client-66-1xx-1x-x14:~ brent1a$ PATH=$PATH:/usr/local/pgsql/bin:/opt/local/bin</div><div>client-66-1xx-1x-x14:~ brent1a$ cd /psqlodbc-08.03.0200 </div><div>client-66-1xx-1x-x14:psqlodbc-08.03.0200 brent1a$ sudo ./configure</div><div>checking for a BSD-compatible install... /usr/bin/install -c</div><div>checking whether build environment is sane... yes</div><div>checking for gawk... no</div><div>checking for mawk... no</div><div>checking for nawk... no</div><div>checking for awk... awk</div><div>checking whether make sets $(MAKE)... yes</div><div>checking whether to enable maintainer-specific po
rtions of Makefiles... no</div><div>checking for pg_config... /usr/local/pgsql/bin/pg_config</div><div>checking for gcc...
gcc</div></div><div>...........</div><div>checking how to hardcode library paths into programs... immediate</div><div>checking for library containing SQLGetPrivateProfileString... no</div><div><b><span class="Apple-style-span" style="text-decoration: underline;">configure: error: unixODBC library "odbcinst" not found</span></b></div><div>client-66-1xx-1x-x14:psqlodbc-08.03.0200 brent1a$ </div><div><br></div></div><div style="font-family:arial, helvetica, sans-serif;font-size:12pt"><br><div style="font-family:arial, helvetica, sans-serif;font-size:13px">----- Original Message ----<br>From: Jeremy Faith <jfaith [at] cemsys.com><br>To: pgsql-odbc [at] postgresql.org<br>Sent: Monday, September 22, 2008 4:06:28 AM<br>Subject: Re: [ODBC] compiling odbc<br><br>
Hi,<br><br>I think what Tom is saying is to try:-<br> PATH=$PATH:/usr/local/pgsql:/opt/local/bin<br><br>Regards,<br>Jeremy Faith<br><br>Brent Austin wrote:<br>> Yes, two PATH items, I guess.<br>> "export PATH=$PATH:/usr/local/pgsql"<br>> <br>> takes care of:<br>> <br>> "checking for pg_config... no<br>> configure: error: pg_config not found (set PG_CONFIG environment <br>> variable)"<br>> <br>> How can I take care of the following as well with out messing up the <br>> above?<br>><br>> "configure: error: unixODBC library "odbcinst" not found"<br>><br>> (I found "odbcinst" is in my /opt/local/bin)<br>><br>> ----- Original Message ----<br>> From: Tom Lane <<a ymailto="mailto:tgl [at] sss.pgh.pa.us" href="mailto:tgl [at] ss
s.pgh.pa.us">tgl [at] sss.pgh.pa.us</a>><br>> To: Brent Austin <<a ymailto="mailto:brent1a [at] yahoo.com"
href="mailto:brent1a [at] yahoo.com">brent1a [at] yahoo.com</a>><br>> Cc: Jeremy Faith <<a ymailto="mailto:jfaith [at] cemsys.com" href="mailto:jfaith [at] cemsys.com">jfaith [at] cemsys.com</a>>; <a ymailto="mailto:pgsql-odbc [at] postgresql.org" href="mailto:pgsql-odbc [at] postgresql.org">pgsql-odbc [at] postgresql.org</a><br>> Sent: Friday, September 19, 2008 3:11:36 PM<br>> Subject: Re: [ODBC] compiling odbc<br>><br>> Brent Austin <<a ymailto="mailto:brent1a [at] yahoo.com" href="mailto:brent1a [at] yahoo.com">brent1a [at] yahoo.com</a> <mailto:<a ymailto="mailto:brent1a [at] yahoo.com" href="mailto:brent1a [at] yahoo.com">brent1a [at] yahoo.com</a>>> writes:<br>> > How do I tell configure that pgsql is in /usr/local/pgsql and ALSO <br>> tell it that obcinst is in /opt/local/bin ???<br>><br>> Two PATH
items?<br>><br>> regards, tom lane<br>><br><br><br>-- <br>Sent via pgsql-odbc mailing list (<a
ymailto="mailto:pgsql-odbc [at] postgresql.org" href="mailto:pgsql-odbc [at] postgresql.org">pgsql-odbc [at] postgresq l.org</a>)<br>To make changes to your subscription:<br>http://www.postgresql.org/mailpref/pgsql-odbc<br></div></div><div style="position:fixed"></div></div><br>

</body></html>
--0-1039446695-1222077683=:64809--

Brent Austin [ Mo, 22 September 2008 12:01 ] [ ID #1969992 ]

Re: compiling odbc

Brent Austin =EDrta:
> I still get this:
> client-66-1xx-1x-x14:~ brent1a$
> PATH=3D$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 [at] cemsys.com>
> To: pgsql-odbc [at] 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=3D$PATH:/usr/local/pgsql:/opt/local/bin
>
> Regards,
> Jeremy Faith
>
> Brent Austin wrote:
> > Yes, two PATH items, I guess.
> > "export PATH=3D$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 [at] sss.pgh.pa.us <mailto:tgl [at] sss.pgh.pa.us>>
> > To: Brent Austin <brent1a [at] yahoo.com <mailto:brent1a [at] yahoo.com>>
> > Cc: Jeremy Faith <jfaith [at] cemsys.com <mailto:jfaith [at] cemsys.com>>;
> pgsql-odbc [at] postgresql.org <mailto:pgsql-odbc [at] postgresql.org>
> > Sent: Friday, September 19, 2008 3:11:36 PM
> > Subject: Re: [ODBC] compiling odbc
> >
> > Brent Austin <brent1a [at] yahoo.com <mailto:brent1a [at] yahoo.com>
> <mailto:brent1a [at] yahoo.com <mailto:brent1a [at] 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 [at] postgresql.org
> <mailto:pgsql-odbc [at] postgresql.org>)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-odbc
>

--
----------------------------------
Zolt=E1n Böszörm=E9nyi
Cybertec Schönig & Schönig GmbH
http://www.postgresql.at/

--
Sent via pgsql-odbc mailing list (pgsql-odbc [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc

Zoltan Boszormenyi [ Mo, 22 September 2008 12:36 ] [ ID #1969993 ]

Re: compiling odbc

--0-1483291421-1222104529=:58269
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

That's the thing, I have unixODBC installed, it is located at /opt/local/bi=
n 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. =
=0APATH=3D$PATH:/usr/local/pgsql/bin:/opt/local/bin should work but it's =
not recognizing the second part.....the odncinst part.=0A=0A=0A=0A----- Ori=
ginal Message ----=0AFrom: Zoltan Boszormenyi <zb [at] cybertec.at>=0ATo: Brent =
Austin <brent1a [at] yahoo.com>=0ACc: Jeremy Faith <jfaith [at] cemsys.com>; pgsql-od=
bc [at] postgresql.org=0ASent: Monday, September 22, 2008 5:36:19 AM=0ASubject: =
Re: [ODBC] compiling odbc=0A=0ABrent Austin =EDrta:=0A> I still get this: =
=0A> client-66-1xx-1x-x14:~ brent1a$=0A> PATH=3D$PATH:/usr/local/pgsql/bin=
:/opt/local/bin=0A> client-66-1xx-1x-x14:~ brent1a$ cd /psqlodbc-08.03.0200=
=0A> client-66-1xx-1x-x14:psqlodbc-08.03.0200 brent1a$ sudo ./configure=0A=
> checking for a BSD-compatible install... /usr/bin/install -c=0A> checking=
whether build environment is sane... yes=0A> checking for gawk... no=0A> c=
hecking for mawk... no=0A> checking for nawk... no=0A> checking for awk... =
awk=0A> checking whether make sets $(MAKE)... yes=0A> checking whether to e=
nable maintainer-specific portions of Makefiles... no=0A> checking for pg_c=
onfig... /usr/local/pgsql/bin/pg_config=0A> checking for gcc... gcc=0A> ...=
.........=0A> checking how to hardcode library paths into programs... immedi=
ate=0A> checking for library containing SQLGetPrivateProfileString... no=0A=
> *configure: error: unixODBC library "odbcinst" not found*=0A> client-66-1=
xx-1x-x14:psqlodbc-08.03.0200 brent1a$=0A=0AYou need unixODBC or iODBC inst=
alled. unixODBC is used by default,=0Ayou can change the expected ODBC mana=
ger with option --with-iodbc.=0A=0A> ----- Original Message ----=0A> From: =
Jeremy Faith <jfaith [at] cemsys.com>=0A> To: pgsql-odbc [at] postgresql.org=0A> Sent=
: Monday, September 22, 2008 4:06:28 AM=0A> Subject: Re: [ODBC] compiling o=
dbc=0A>=0A> Hi,=0A>=0A> I think what Tom is saying is to try:-=0A> PATH=
=3D$PATH:/usr/local/pgsql:/opt/local/bin=0A>=0A> Regards,=0A> Jeremy Faith=
=0A>=0A> Brent Austin wrote:=0A> > Yes, two PATH items, I guess.=0A> > "exp=
ort PATH=3D$PATH:/usr/local/pgsql"=0A> > =0A> > takes care of:=0A> > =0A> >=
"checking for pg_config... no=0A> > configure: error: pg_config not found =
(set PG_CONFIG environment=0A> > variable)"=0A> > =0A> > How can I take car=
e of the following as well with out messing up the=0A> > above?=0A> >=0A> >=
"configure: error: unixODBC library "odbcinst" not found"=0A> >=0A> > (I f=
ound "odbcinst" is in my /opt/local/bin)=0A> >=0A> > ----- Original Message=
----=0A> > From: Tom Lane <tgl [at] sss.pgh.pa.us <mailto:tgl [at] sss.pgh.pa.us>>=
=0A> > To: Brent Austin <brent1a [at] yahoo.com <mailto:brent1a [at] yahoo.com>>=0A> =
> Cc: Jeremy Faith <jfaith [at] cemsys.com <mailto:jfaith [at] cemsys.com>>;=0A> pgsq=
l-odbc [at] postgresql.org <mailto:pgsql-odbc [at] postgresql.org>=0A> > Sent: Friday=
, September 19, 2008 3:11:36 PM=0A> > Subject: Re: [ODBC] compiling odbc=0A=
> >=0A> > Brent Austin <brent1a [at] yahoo.com <mailto:brent1a [at] yahoo.com>=0A> <m=
ailto:brent1a [at] yahoo.com <mailto:brent1a [at] yahoo.com>>> writes:=0A> > > How do=
I tell configure that pgsql is in /usr/local/pgsql and ALSO=0A> > tell it =
that obcinst is in /opt/local/bin ???=0A> >=0A> > Two PATH items?=0A> >=0A>=
> regards, tom lane=0A> >=0A>=0A>=0A> -- =0A> Sent via pgsql-od=
bc mailing list (pgsql-odbc [at] postgresql.org=0A> <mailto:pgsql-odbc [at] postgresq=
l.org>)=0A> To make changes to your subscription:=0A> http://www.postgresql=
..org/mailpref/pgsql-odbc=0A>=0A=0A=0A-- =0A--------------------------------=
--=0AZolt=E1n Böszörm=E9nyi=0ACybertec Schönig & Schönig GmbH=0Ahtt=
p://www.postgresql.at/=0A=0A=0A
--0-1483291421-1222104529=:58269
Content-Type: text/html; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

<html><head><style type=3D"text/css"></style></he=
ad><body><div style=3D"font-family:arial, helvetica, sans-serif;font-size:1=
2pt"><div><span class=3D"Apple-style-span" style=3D"font-size: 13px; ">That=
's the thing, I have unixODBC installed, it is located at /opt/local/b=
in that is why I need help figuring out how to get the terminal to recogniz=
e where both pg_config AND obdcinst are at during the ./configure process. =
</span></div><div style=3D"font-family:arial, helvetica, sans-serif;f=
ont-size:12pt"><span class=3D"Apple-style-span" style=3D"font-size: 13px; "=
>PATH=3D$PATH:/usr/local/pgsql/bin:/opt/local/bin should work but it=
's not recognizing the second part.....the odncinst part.</span></div><div =
style=3D"font-family:arial, helvetica, sans-serif;font-size:12pt"><font cla=
ss=3D"Apple-style-span" size=3D"3"><span class=3D"Apple-style-span" style=
=3D"font-size: 13px;"><br></span></font></div><div style=3D"font-family:ari=
al, helvetica,
sans-serif;font-size:12pt"><font class=3D"Apple-style-span" size=3D"3"><sp=
an class=3D"Apple-style-span" style=3D"font-size: 13px;"><br></span></font>=
<div style=3D"font-family:arial, helvetica, sans-serif;font-size:13px">----=
- Original Message ----<br>From: Zoltan Boszormenyi <zb [at] cybertec.at><=
br>To: Brent Austin <brent1a [at] yahoo.com><br>Cc: Jeremy Faith <jfait=
h [at] cemsys.com>; pgsql-odbc [at] postgresql.org<br>Sent: Monday, September 22, =
2008 5:36:19 AM<br>Subject: Re: [ODBC] compiling odbc<br><br>=0ABrent Austi=
n =EDrta:<br>> I still get this: <br>> client-66-1xx-1x-x=
14:~ brent1a$<br>> PATH=3D$PATH:/usr/local/pgsql/bin:/opt/local/bin<br>&=
gt; client-66-1xx-1x-x14:~ brent1a$ cd /psqlodbc-08.03.0200 <br>> client=
-66-1xx-1x-x14:psqlodbc-08.03.0200 brent1a$ sudo ./configure<br>> checki=
ng for a BSD-compatible install... /usr/bin/install -c<br>> checking whe=
ther build environment is sane... yes<br>> checking for gawk... no<br>&g=
t; checking for mawk... no<br>> checking for nawk... no<br>> checking=
for awk... awk<br>> checking whether make sets $(MAKE)... yes<br>> c=
hecking whether to enable maintainer-specific portions of Makefiles... no<b=
r>> checking for pg_config... /usr/local/pgsql/bin/pg_config<br>> che=
cking for gcc... gcc<br>> ...........<br>> checking how to hardcode l=
ibrary paths into programs... immediate<br>> checking for library contai=
ning SQLGetPrivateProfileString... no<br>> *configure:
error: unixODBC library "odbcinst" not found*<br>> client-66-1xx-1x-x14=
:psqlodbc-08.03.0200 brent1a$<br><br>You need unixODBC or iODBC installed. =
unixODBC is used by default,<br>you can change the expected ODBC manager wi=
th option --with-iodbc.<br><br>> ----- Original Message ----<br>> Fro=
m: Jeremy Faith <<a ymailto=3D"mailto:jfaith [at] cemsys.com" href=3D"mailto:=
jfaith [at] cemsys.com">jfaith [at] cemsys.com</a>><br>> To: <a ymailto=3D"mail=
to:pgsql-odbc [at] postgresql.org" href=3D"mailto:pgsql-odbc [at] postgresql.org">pgs=
ql-odbc [at] postgresql.org</a><br>> Sent: Monday, September 22, 2008 4:06:28=
AM<br>> Subject: Re: [ODBC] compiling odbc<br>><br>> Hi,<br>><=
br>> I think what Tom is saying is to try:-<br>> PATH=3D$PATH:=
/usr/local/pgsql:/opt/local/bin<br>><br>> Regards,<br>> Jeremy Fai=
th<br>><br>> Brent Austin wrote:<br>> > Yes, two PATH items, I =
guess.<br>> > "export PATH=3D$PATH:/usr/local/pgsql"<br>> > <br=
>>
> takes care of:<br>> > <br>> > "checking for pg_config... =
no<br>> > configure: error: pg_config not found (set PG_CONFIG enviro=
nment<br>> > variable)"<br>> > <br>> > How can I take car=
e of the following as well with out messing up the<br>> > above?<br>&=
gt; ><br>> > "configure: error: unixODBC library "odbcinst" not fo=
und"<br>> ><br>> > (I found "odbcinst" is in my /opt/local/bin)=
<br>> ><br>> > ----- Original Message ----<br>> > From: T=
om Lane <<a ymailto=3D"mailto:tgl [at] sss.pgh.pa.us" href=3D"mailto:tgl [at] sss.=
pgh.pa.us">tgl [at] sss.pgh.pa.us</a> <mailto:<a ymailto=3D"mailto:tgl [at] sss.pg=
h.pa.us" href=3D"mailto:tgl [at] sss.pgh.pa.us">tgl [at] sss.pgh.pa.us</a>>><br=
>> > To: Brent Austin <<a ymailto=3D"mailto:brent1a [at] yahoo.com" hre=
f=3D"mailto:brent1a [at] yahoo.com">brent1a [at] yahoo.com</a> <mailto:<a ymailto=
=3D"mailto:brent1a [at] yahoo.com"
href=3D"mailto:brent1a [at] yahoo.com">brent1a [at] yahoo.com</a>>><br>> &g=
t; Cc: Jeremy Faith <<a ymailto=3D"mailto:jfaith [at] cemsys.com" href=3D"mai=
lto:jfaith [at] cemsys.com">jfaith [at] cemsys.com</a> <mailto:<a ymailto=3D"mailt=
o:jfaith [at] cemsys.com" href=3D"mailto:jfaith [at] cemsys.com">jfaith [at] cemsys.com</a=
>>>;<br>> <a ymailto=3D"mailto:pgsql-odbc [at] postgresql.org" href=3D"=
mailto:pgsql-odbc [at] postgresql.org">pgsql-odbc [at] postgresql.org</a> <mailto:=
<a ymailto=3D"mailto:pgsql-odbc [at] postgresql.org" href=3D"mailto:pgsql-odbc [at] p=
ostgresql.org">pgsql-odbc [at] postgresql.org</a>><br>> > Sent: Friday,=
September 19, 2008 3:11:36 PM<br>> > Subject: Re: [ODBC] compiling o=
dbc<br>> ><br>> > Brent Austin <<a ymailto=3D"mailto:brent1a=
[at] yahoo.com" href=3D"mailto:brent1a [at] yahoo.com">brent1a [at] yahoo.com</a> <mai=
lto:<a ymailto=3D"mailto:brent1a [at] yahoo.com" href=3D"mailto:brent1a [at] yahoo.co=
m">brent1a [at] yahoo.com</a>><br>> <mailto:<a ymailto=3D"mailto:brent1=
a [at] yahoo.com"
href=3D"mailto:brent1a [at] yahoo.com">brent1a [at] yahoo.com</a> <mailto:<a ymai=
lto=3D"mailto:brent1a [at] yahoo.com" href=3D"mailto:brent1a [at] yahoo.com">brent1a [at] =
yahoo.com</a>>>> writes:<br>> > > How do I tell configure=
that pgsql is in /usr/local/pgsql and ALSO<br>> > tell it that obcin=
st is in /opt/local/bin ???<br>> ><br>> > Two PATH items?<br>&g=
t; ><br>> > regards, tom =
lane<br>> ><br>><br>><br>> -- <br>> Sent via pgsql-odbc m=
ailing list (<a ymailto=3D"mailto:pgsql-odbc [at] postgresql.org" href=3D"mailto=
:pgsql-odbc [at] postgresql.org">pgsql-odbc [at] postgresql.org</a><br>> <mailt=
o:<a ymailto=3D"mailto:pgsql-odbc [at] postgresql.org" href=3D"mailto:pgsql-odbc=
[at] postgresql.org">pgsql-odbc [at] postgresql.org</a>>)<br>> To make changes=
to your subscription:<br>> <a href=3D"http://www.postgresql.org/mailpre=
f/pgsql-odbc"
target=3D"_blank">http://www.postgresql.org/mailpref/pgsql-o dbc</a><br>>=
;<br><br><br>-- <br>----------------------------------<br>Zolt=E1n Bösz=
örm=E9nyi<br>Cybertec Schönig & Schönig GmbH<br><a href=3D"http:/=
/www.postgresql.at/" target=3D"_blank">http://www.postgresql.at/</a><br><br=
></div></div><div style=3D"position:fixed"></div></div><br>=0A=0A </bo=
dy></html>
--0-1483291421-1222104529=:58269--

Brent Austin [ Mo, 22 September 2008 19:28 ] [ ID #1969994 ]

Re: compiling odbc

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

--
Sent via pgsql-odbc mailing list (pgsql-odbc [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc

Peter Eisentraut [ Di, 23 September 2008 09:48 ] [ ID #1970194 ]

Re: compiling odbc

> 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 [at] developer:~$ which odbc_config
/usr/local/bin/odbc_config
hiroshi [at] 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

--
Sent via pgsql-odbc mailing list (pgsql-odbc [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc

Hiroshi Saito [ Di, 23 September 2008 10:02 ] [ ID #1970195 ]

Datenbanken » gmane.comp.db.postgresql.odbc » compiling odbc

Vorheriges Thema: Soalris compiller error for driver 08.03.0300
Nächstes Thema: Problem with using SOCK_put_int method PGAPI_PutData