[pgpool-general: 8791] Re: Cannot configure with the correct psql path

[Bo Peng]

Hi,

Because pgpool can't find the library, 
you need to specify the top directory where PostgreSQL was installed by using "--with-pgsql",
or specify "--with-pgsql-includedir" and "--with-pgsql-libdir".

Please run pg_config command to get the path of your INCLUDEDIR and LIBDIR.

On Thu, 1 Jun 2023 13:54:24 +0800
Zhaoxun Yan <yan.zhaoxun at gmail.com> wrote:

> Have installed that, but it won't work:
> 
> Installed:
>   postgresql15-devel.x86_64 0:15.3-1PGDG.rhel7
> 
> Dependency Installed:
>   audit-libs-python.x86_64 0:2.8.5-4.el7
>   checkpolicy.x86_64 0:2.5-8.el7
>   devtoolset-7-binutils.x86_64 0:2.28-11.el7
>   devtoolset-7-gcc.x86_64 0:7.3.1-5.16.el7
>   devtoolset-7-gcc-c++.x86_64 0:7.3.1-5.16.el7
>   devtoolset-7-libstdc++-devel.x86_64 0:7.3.1-5.16.el7
>   devtoolset-7-runtime.x86_64 0:7.1-4.el7
>   libcgroup.x86_64 0:0.41-21.el7
>   libedit-devel.x86_64 0:3.0-12.20121213cvs.el7
>   libicu-devel.x86_64 0:50.2-4.el7_7
>   libsemanage-python.x86_64 0:2.5-14.el7
>   llvm-toolset-7-clang.x86_64 0:5.0.1-4.el7
>   llvm-toolset-7-clang-libs.x86_64 0:5.0.1-4.el7
>   llvm-toolset-7-compiler-rt.x86_64 0:5.0.1-2.el7
>   llvm-toolset-7-libomp.x86_64 0:5.0.1-2.el7
>   llvm-toolset-7-llvm-libs.x86_64 0:5.0.1-8.el7
>   llvm-toolset-7-runtime.x86_64 0:5.0.1-4.el7
>   llvm5.0.x86_64 0:5.0.1-7.el7
>   llvm5.0-devel.x86_64 0:5.0.1-7.el7
>   llvm5.0-libs.x86_64 0:5.0.1-7.el7
>   ncurses-devel.x86_64 0:5.9-14.20130511.el7_4
>   perl-Data-Dumper.x86_64 0:2.145-3.el7
>   perl-IO-Tty.x86_64 0:1.10-11.el7
>   perl-IPC-Run.noarch 0:0.92-2.el7
>   perl-Test-Harness.noarch 0:3.28-3.el7
>   perl-Test-Simple.noarch 0:0.98-243.el7
>   policycoreutils-python.x86_64 0:2.5-34.el7
>   python-IPy.noarch 0:0.75-6.el7
>   scl-utils.x86_64 0:20130529-19.el7
>   setools-libs.x86_64 0:3.3.8-4.el7
> 
> Complete!
> 
> [root at yzx1 ~]# cd  pgpool-II-4.4.3
> [root at yzx1 pgpool-II-4.4.3]# ./configure --prefix=/usr
> checking for gcc... gcc
> checking whether the C compiler works... yes
> ......
> 
> checking for __builtin_types_compatible_p... yes
> checking for pg_config... no
> checking for PQexecPrepared in -lpq... no
> configure: error: libpq is not installed or libpq is old
> 
> 
> On Thu, Jun 1, 2023 at 8:54 AM Bo Peng <pengbo at sraoss.co.jp> wrote:
> 
> > Hi,
> >
> > > Hi guys!
> > >
> > > I found the psql path by
> > >  pgpool-II-4.4.3]# which psql
> > > /usr/bin/psql
> > >
> > > I run this command with the actual psql path on the server
> > > ./configure --prefix=/usr --with-pgsql=/usr/bin/psql
> > >
> > > but it still fails like this:
> > > checking for pstat... no
> > > checking for setproctitle... no
> > > checking for syslog... yes
> > > checking for __builtin_types_compatible_p... yes
> > > checking for pg_config... no
> > > checking for PQexecPrepared in -lpq... no
> > > configure: error: libpq is not installed or libpq is old
> >
> > I assume you are uing the PostgreSQL packages provided by distribution.
> > To use libpq you will need the header files included in postgresql-devel.
> >
> > Please install postgresql-devel, then try ./configure again.
> >
> > Pgpool-II will read the library paths from pg_config installed under
> > /usr/bin/.
> > In this case I think you don't need to specify --with-pgsql.
> >
> > --
> > Bo Peng <pengbo at sraoss.co.jp>
> > SRA OSS LLC
> > https://www.sraoss.co.jp/
> >


-- 
Bo Peng <pengbo at sraoss.co.jp>
SRA OSS LLC
https://www.sraoss.co.jp/