[Pgpool-general] pgpool-II compile issues

[Yoshiyuki Asaba]

Hi,

From: "Nate Tallman" <nate.tallman at connectivhealth.com>
Subject: Re: [Pgpool-general] pgpool-II compile issues
Date: Wed, 28 May 2008 16:01:00 -0500

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

Thank you for the report.
I'll check it.

Regards,
--
Yoshiyuki Asaba
y-asaba at sraoss.co.jp


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