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

[Zhaoxun Yan]

I have found this from serverfault, which worked:

export PATH=$PATH:/usr/pgsql-15/bin



On Thu, Jun 1, 2023 at 2:17 PM Bo Peng <pengbo at sraoss.co.jp> wrote:

> 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/
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20230601/a187aaa9/attachment.htm>