<div dir="ltr">I have found this from serverfault, which worked:<br>
<p class="gmail-a" style="margin-bottom:6pt;margin-right:0cm;margin-left:0cm;background:rgb(38,38,38) none repeat scroll 0% 0%;font-size:12pt;font-family:宋体;color:rgb(238,236,225)"><span lang="EN-US">export
PATH=$PATH:/usr/pgsql-15/bin</span></p>
<br><br></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Thu, Jun 1, 2023 at 2:17 PM Bo Peng <<a href="mailto:pengbo@sraoss.co.jp">pengbo@sraoss.co.jp</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">Hi,<br>
<br>
Because pgpool can't find the library, <br>
you need to specify the top directory where PostgreSQL was installed by using "--with-pgsql",<br>
or specify "--with-pgsql-includedir" and "--with-pgsql-libdir".<br>
<br>
Please run pg_config command to get the path of your INCLUDEDIR and LIBDIR.<br>
<br>
On Thu, 1 Jun 2023 13:54:24 +0800<br>
Zhaoxun Yan <<a href="mailto:yan.zhaoxun@gmail.com" target="_blank">yan.zhaoxun@gmail.com</a>> wrote:<br>
<br>
> Have installed that, but it won't work:<br>
> <br>
> Installed:<br>
> postgresql15-devel.x86_64 0:15.3-1PGDG.rhel7<br>
> <br>
> Dependency Installed:<br>
> audit-libs-python.x86_64 0:2.8.5-4.el7<br>
> checkpolicy.x86_64 0:2.5-8.el7<br>
> devtoolset-7-binutils.x86_64 0:2.28-11.el7<br>
> devtoolset-7-gcc.x86_64 0:7.3.1-5.16.el7<br>
> devtoolset-7-gcc-c++.x86_64 0:7.3.1-5.16.el7<br>
> devtoolset-7-libstdc++-devel.x86_64 0:7.3.1-5.16.el7<br>
> devtoolset-7-runtime.x86_64 0:7.1-4.el7<br>
> libcgroup.x86_64 0:0.41-21.el7<br>
> libedit-devel.x86_64 0:3.0-12.20121213cvs.el7<br>
> libicu-devel.x86_64 0:50.2-4.el7_7<br>
> libsemanage-python.x86_64 0:2.5-14.el7<br>
> llvm-toolset-7-clang.x86_64 0:5.0.1-4.el7<br>
> llvm-toolset-7-clang-libs.x86_64 0:5.0.1-4.el7<br>
> llvm-toolset-7-compiler-rt.x86_64 0:5.0.1-2.el7<br>
> llvm-toolset-7-libomp.x86_64 0:5.0.1-2.el7<br>
> llvm-toolset-7-llvm-libs.x86_64 0:5.0.1-8.el7<br>
> llvm-toolset-7-runtime.x86_64 0:5.0.1-4.el7<br>
> llvm5.0.x86_64 0:5.0.1-7.el7<br>
> llvm5.0-devel.x86_64 0:5.0.1-7.el7<br>
> llvm5.0-libs.x86_64 0:5.0.1-7.el7<br>
> ncurses-devel.x86_64 0:5.9-14.20130511.el7_4<br>
> perl-Data-Dumper.x86_64 0:2.145-3.el7<br>
> perl-IO-Tty.x86_64 0:1.10-11.el7<br>
> perl-IPC-Run.noarch 0:0.92-2.el7<br>
> perl-Test-Harness.noarch 0:3.28-3.el7<br>
> perl-Test-Simple.noarch 0:0.98-243.el7<br>
> policycoreutils-python.x86_64 0:2.5-34.el7<br>
> python-IPy.noarch 0:0.75-6.el7<br>
> scl-utils.x86_64 0:20130529-19.el7<br>
> setools-libs.x86_64 0:3.3.8-4.el7<br>
> <br>
> Complete!<br>
> <br>
> [root@yzx1 ~]# cd pgpool-II-4.4.3<br>
> [root@yzx1 pgpool-II-4.4.3]# ./configure --prefix=/usr<br>
> checking for gcc... gcc<br>
> checking whether the C compiler works... yes<br>
> ......<br>
> <br>
> checking for __builtin_types_compatible_p... yes<br>
> checking for pg_config... no<br>
> checking for PQexecPrepared in -lpq... no<br>
> configure: error: libpq is not installed or libpq is old<br>
> <br>
> <br>
> On Thu, Jun 1, 2023 at 8:54 AM Bo Peng <<a href="mailto:pengbo@sraoss.co.jp" target="_blank">pengbo@sraoss.co.jp</a>> wrote:<br>
> <br>
> > Hi,<br>
> ><br>
> > > Hi guys!<br>
> > ><br>
> > > I found the psql path by<br>
> > > pgpool-II-4.4.3]# which psql<br>
> > > /usr/bin/psql<br>
> > ><br>
> > > I run this command with the actual psql path on the server<br>
> > > ./configure --prefix=/usr --with-pgsql=/usr/bin/psql<br>
> > ><br>
> > > but it still fails like this:<br>
> > > checking for pstat... no<br>
> > > checking for setproctitle... no<br>
> > > checking for syslog... yes<br>
> > > checking for __builtin_types_compatible_p... yes<br>
> > > checking for pg_config... no<br>
> > > checking for PQexecPrepared in -lpq... no<br>
> > > configure: error: libpq is not installed or libpq is old<br>
> ><br>
> > I assume you are uing the PostgreSQL packages provided by distribution.<br>
> > To use libpq you will need the header files included in postgresql-devel.<br>
> ><br>
> > Please install postgresql-devel, then try ./configure again.<br>
> ><br>
> > Pgpool-II will read the library paths from pg_config installed under<br>
> > /usr/bin/.<br>
> > In this case I think you don't need to specify --with-pgsql.<br>
> ><br>
> > --<br>
> > Bo Peng <<a href="mailto:pengbo@sraoss.co.jp" target="_blank">pengbo@sraoss.co.jp</a>><br>
> > SRA OSS LLC<br>
> > <a href="https://www.sraoss.co.jp/" rel="noreferrer" target="_blank">https://www.sraoss.co.jp/</a><br>
> ><br>
<br>
<br>
-- <br>
Bo Peng <<a href="mailto:pengbo@sraoss.co.jp" target="_blank">pengbo@sraoss.co.jp</a>><br>
SRA OSS LLC<br>
<a href="https://www.sraoss.co.jp/" rel="noreferrer" target="_blank">https://www.sraoss.co.jp/</a><br>
</blockquote></div>