[pgpool-general: 8791] Re: Cannot configure with the correct psql path
Bo Peng
pengbo at sraoss.co.jp
Thu Jun 1 15:17:21 JST 2023
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/
More information about the pgpool-general
mailing list