[Pgpool-general] pgpool-II compile issues

[Nate Tallman]

Ok, Got it working.
Here's the procedure in case anyone else stumbles upon this:
export CFLAGS='-ldl'
ln -s /path/to/real/libpq.so /usr/local/lib/
export PATH=$PATH:/path/to/postgres/bin

Why it works (I think):
Firstly, postgres wasn't compiled with -ldl (prob should have been though)
and the problem isn't in pgpool, but wrather with libpq at the postgres
compile time. Setting CFLAGS to '-ldl' patches that.
Secondly, for some reason configure isn't looking for libpq in your postgres
lib directory even though you may explicitely define that or configure may
find that directory. It looks in /usr/lib though.
Lastly, pg_config needs to be in your path.

Hope this helps anyone else.
If anyone has any other explanations or comments, please share.

Nate Tallman


On Wed, May 28, 2008 at 12:17 PM, Nate Tallman <
nate.tallman at connectivhealth.com> wrote:

> I'm still having issues with configure not finding or liking libpq.
>
> ./configure --prefix=/usr/local --with-pgsql=/usr/local/postgres8.3.1/
> --with-pgsql-includedir=/usr/local/postgres8.3.1/include/
> --with-pgsql-libdir=/usr/local/postgres8.3.1/lib/
>
> checking for pg_config... pg_config
> checking for PQexecPrepared in -lpq... no
> configure: error: libpq is not installed or libpq is old
>
> I ran 'nm /usr/local/postgres8.3.1/lib/libpq.a | grep PQexecPrepared' and
> it came back with:
> 00003150 T PQexecPrepared
>
> Anyone have any suggestions?
>
> Nate Tallman
>
>
> On Fri, May 23, 2008 at 2:21 PM, Nate Tallman <
> nate.tallman at connectivhealth.com> wrote:
>
>> No dice:
>> It finds pg_config, but still errors out on libpq. I verified that libpq
>> is definitely in the specified directories (lib and include).
>>
>>
>> On Fri, May 23, 2008 at 1:43 PM, Yoshiyuki Asaba <y-asaba at sraoss.co.jp>
>> wrote:
>>
>>> Hi,
>>>
>>> From: "Nate Tallman" <nate.tallman at connectivhealth.com>
>>> Subject: [Pgpool-general] pgpool-II compile issues
>>> Date: Fri, 23 May 2008 11:33:43 -0500
>>>
>>> > I'm trying to compile pgpool-II 2.0.1 on a system with postgres 8.3.1
>>> but
>>> > the configure script keeps dying at "libpq is not installed or libpq is
>>> old"
>>> > Likewise, "checking for pg_config" comes back as "no".
>>>
>>> Can you try the following command?
>>>
>>>  % PAHT=/usr/local/postgresql8.3.1/bin:$PATH ./configure \
>>>    --prefix=/usr/local --sysconfigdir=/etc
>>>
>>> Regards,
>>> --
>>> Yoshiyuki Asaba
>>> y-asaba at sraoss.co.jp
>>> _______________________________________________
>>> Pgpool-general mailing list
>>> Pgpool-general at pgfoundry.org
>>> http://pgfoundry.org/mailman/listinfo/pgpool-general
>>>
>>
>>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://pgfoundry.org/pipermail/pgpool-general/attachments/20080528/6568848b/attachment.html