<div dir="ltr">Hi, <div><br></div><div>no, I didn't.</div><div>My original idea was to install pgpool in a different server than postgresql, so I didn't.</div><div><br></div><div>Now, with pgpool installed in the postgresql server, pgpool_adm can be installed.</div><div><br></div><div>At this point, I only have to decide if I want to use these pgpool or if I want to keep them off and go on with the initial design (one or more pgpools in different servers than postgresql).</div><div><br></div><div>Anyway, thank you very much!!</div><div>Matteo M.</div></div><br><div class="gmail_quote"><div dir="ltr">Il giorno gio 8 nov 2018 alle ore 05:54 Tatsuo Ishii <<a href="mailto:ishii@sraoss.co.jp">ishii@sraoss.co.jp</a>> ha scritto:<br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Hi Matteo,<br>
<br>
> Hi all,<br>
> <br>
> I can't compile pgpool_adm (pgpool 4.0.0, but also with 4.0.1 I found the<br>
> same error) on debian 9.5.<br>
> My server has postgresql 10.5 installed on a fresh new installation of<br>
> debian.<br>
> <br>
> Over the fresh machine I installed (after reading lot of guides) these<br>
> packages:<br>
> sudo<br>
> make<br>
> gcc<br>
> libpq-dev<br>
> postgresql-10<br>
> postgresql-server-dev-10<br>
> <br>
> My pgpool installation is on a different server.<br>
> <br>
> but the make command fails as below (maybe I still miss some packages).<br>
> (With the same server I can successfully make pgpool-recovery)<br>
> <br>
> Here the output:<br>
> root@debian-server:/home/user/Scaricati# cd pgpool-II-4.0.0<br>
> root@debian-server:/home/user/Scaricati/pgpool-II-4.0.0# cd<br>
> src/sql/pgpool_adm/<br>
> root@debian-server:/home/user/Scaricati/pgpool-II-4.0.0/src/sql/pgpool_adm#<br>
> make<br>
> gcc -Wall -Wmissing-prototypes -Wpointer-arith<br>
> -Wdeclaration-after-statement -Wendif-labels -Wmissing-format-attribute<br>
> -Wformat-security -fno-strict-aliasing -fwrapv -fexcess-precision=standard<br>
> -g -g -O2 -fstack-protector-strong -Wformat -Werror=format-security<br>
> -fno-omit-frame-pointer -fPIC -I/usr/include/postgresql -I../../include/pcp<br>
> -I. -I./ -I/usr/include/postgresql/10/server<br>
> -I/usr/include/postgresql/internal  -Wdate-time -D_FORTIFY_SOURCE=2<br>
> -D_GNU_SOURCE -I/usr/include/libxml2  -I/usr/include/mit-krb5  -c -o<br>
> pgpool_adm.o pgpool_adm.c<br>
> gcc -Wall -Wmissing-prototypes -Wpointer-arith<br>
> -Wdeclaration-after-statement -Wendif-labels -Wmissing-format-attribute<br>
> -Wformat-security -fno-strict-aliasing -fwrapv -fexcess-precision=standard<br>
> -g -g -O2 -fstack-protector-strong -Wformat -Werror=format-security<br>
> -fno-omit-frame-pointer -fPIC -shared -o pgpool_adm.so pgpool_adm.o<br>
> -L/usr/lib/x86_64-linux-gnu  -Wl,-z,relro -Wl,-z,now<br>
> -L/usr/lib/x86_64-linux-gnu/mit-krb5 -Wl,--as-needed<br>
> -L../../libs/pcp/.libs -lpcp -Wl,--as-needed<br>
> -Wl,-rpath,'/lib',--enable-new-dtags<br>
> /usr/bin/ld: impossibile trovare -lpcp<br>
> collect2: error: ld returned 1 exit status<br>
> /usr/lib/postgresql/10/lib/pgxs/src/makefiles/../../src/Makefile.shlib:292:<br>
> set di istruzioni per l'obiettivo "pgpool_adm.so" non riuscito<br>
> make: *** [pgpool_adm.so] Errore 1<br>
> <br>
> The error is (here the translation)<br>
> /usr/bin/ld: impossible to find -lpcp<br>
> collect2: error: ld returned 1 exit status<br>
> /usr/lib/postgresql/10/lib/pgxs/src/makefiles/../../src/Makefile.shlib:292:<br>
> instruction set for the target "pgpool_adm.so" failed<br>
> make: *** [pgpool_adm.so] Error 1<br>
> <br>
> Thanks for any help!!<br>
> Matteo M.<br>
<br>
You need to install libpcp first. libpcp comes with Pgpool-II<br>
itself. Have you installed Pgpool-II (except pgpool_adm)?<br>
<br>
Best regards,<br>
--<br>
Tatsuo Ishii<br>
SRA OSS, Inc. Japan<br>
English: <a href="https://urldefense.proofpoint.com/v2/url?u=http-3A__www.sraoss.co.jp_index-5Fen.php&d=DwICAg&c=z7ZdhQWiOKyPuOPFlqJIyw&r=EozxJ07eZdUti5lcY_lysVNm7ciSa1TsqyT6WzR_9a8&m=8UVVRcJ0lrZ9dyh80rbG_ui9TmkKGqxbpb73nPjXsI4&s=dDfWz6uxRZERF2g909S7ijMu-BdU5YyIM0BUhCSODlU&e=" rel="noreferrer" target="_blank">https://urldefense.proofpoint.com/v2/url?u=http-3A__www.sraoss.co.jp_index-5Fen.php&d=DwICAg&c=z7ZdhQWiOKyPuOPFlqJIyw&r=EozxJ07eZdUti5lcY_lysVNm7ciSa1TsqyT6WzR_9a8&m=8UVVRcJ0lrZ9dyh80rbG_ui9TmkKGqxbpb73nPjXsI4&s=dDfWz6uxRZERF2g909S7ijMu-BdU5YyIM0BUhCSODlU&e=</a><br>
Japanese:<a href="https://urldefense.proofpoint.com/v2/url?u=http-3A__www.sraoss.co.jp&d=DwICAg&c=z7ZdhQWiOKyPuOPFlqJIyw&r=EozxJ07eZdUti5lcY_lysVNm7ciSa1TsqyT6WzR_9a8&m=8UVVRcJ0lrZ9dyh80rbG_ui9TmkKGqxbpb73nPjXsI4&s=5a0EQrFGsXBVyWTw9_Fr7YI3uPnaI-fFWfPT9u3vkdA&e=" rel="noreferrer" target="_blank">https://urldefense.proofpoint.com/v2/url?u=http-3A__www.sraoss.co.jp&d=DwICAg&c=z7ZdhQWiOKyPuOPFlqJIyw&r=EozxJ07eZdUti5lcY_lysVNm7ciSa1TsqyT6WzR_9a8&m=8UVVRcJ0lrZ9dyh80rbG_ui9TmkKGqxbpb73nPjXsI4&s=5a0EQrFGsXBVyWTw9_Fr7YI3uPnaI-fFWfPT9u3vkdA&e=</a><br>
</blockquote></div>