<div dir="ltr">Hi, <div><br></div><div>no, I didn&#39;t.</div><div>My original idea was to install pgpool in a different server than postgresql, so I didn&#39;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 &lt;<a href="mailto:ishii@sraoss.co.jp">ishii@sraoss.co.jp</a>&gt; 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>
&gt; Hi all,<br>
&gt; <br>
&gt; I can&#39;t compile pgpool_adm (pgpool 4.0.0, but also with 4.0.1 I found the<br>
&gt; same error) on debian 9.5.<br>
&gt; My server has postgresql 10.5 installed on a fresh new installation of<br>
&gt; debian.<br>
&gt; <br>
&gt; Over the fresh machine I installed (after reading lot of guides) these<br>
&gt; packages:<br>
&gt; sudo<br>
&gt; make<br>
&gt; gcc<br>
&gt; libpq-dev<br>
&gt; postgresql-10<br>
&gt; postgresql-server-dev-10<br>
&gt; <br>
&gt; My pgpool installation is on a different server.<br>
&gt; <br>
&gt; but the make command fails as below (maybe I still miss some packages).<br>
&gt; (With the same server I can successfully make pgpool-recovery)<br>
&gt; <br>
&gt; Here the output:<br>
&gt; root@debian-server:/home/user/Scaricati# cd pgpool-II-4.0.0<br>
&gt; root@debian-server:/home/user/Scaricati/pgpool-II-4.0.0# cd<br>
&gt; src/sql/pgpool_adm/<br>
&gt; root@debian-server:/home/user/Scaricati/pgpool-II-4.0.0/src/sql/pgpool_adm#<br>
&gt; make<br>
&gt; gcc -Wall -Wmissing-prototypes -Wpointer-arith<br>
&gt; -Wdeclaration-after-statement -Wendif-labels -Wmissing-format-attribute<br>
&gt; -Wformat-security -fno-strict-aliasing -fwrapv -fexcess-precision=standard<br>
&gt; -g -g -O2 -fstack-protector-strong -Wformat -Werror=format-security<br>
&gt; -fno-omit-frame-pointer -fPIC -I/usr/include/postgresql -I../../include/pcp<br>
&gt; -I. -I./ -I/usr/include/postgresql/10/server<br>
&gt; -I/usr/include/postgresql/internal  -Wdate-time -D_FORTIFY_SOURCE=2<br>
&gt; -D_GNU_SOURCE -I/usr/include/libxml2  -I/usr/include/mit-krb5  -c -o<br>
&gt; pgpool_adm.o pgpool_adm.c<br>
&gt; gcc -Wall -Wmissing-prototypes -Wpointer-arith<br>
&gt; -Wdeclaration-after-statement -Wendif-labels -Wmissing-format-attribute<br>
&gt; -Wformat-security -fno-strict-aliasing -fwrapv -fexcess-precision=standard<br>
&gt; -g -g -O2 -fstack-protector-strong -Wformat -Werror=format-security<br>
&gt; -fno-omit-frame-pointer -fPIC -shared -o pgpool_adm.so pgpool_adm.o<br>
&gt; -L/usr/lib/x86_64-linux-gnu  -Wl,-z,relro -Wl,-z,now<br>
&gt; -L/usr/lib/x86_64-linux-gnu/mit-krb5 -Wl,--as-needed<br>
&gt; -L../../libs/pcp/.libs -lpcp -Wl,--as-needed<br>
&gt; -Wl,-rpath,&#39;/lib&#39;,--enable-new-dtags<br>
&gt; /usr/bin/ld: impossibile trovare -lpcp<br>
&gt; collect2: error: ld returned 1 exit status<br>
&gt; /usr/lib/postgresql/10/lib/pgxs/src/makefiles/../../src/Makefile.shlib:292:<br>
&gt; set di istruzioni per l&#39;obiettivo &quot;pgpool_adm.so&quot; non riuscito<br>
&gt; make: *** [pgpool_adm.so] Errore 1<br>
&gt; <br>
&gt; The error is (here the translation)<br>
&gt; /usr/bin/ld: impossible to find -lpcp<br>
&gt; collect2: error: ld returned 1 exit status<br>
&gt; /usr/lib/postgresql/10/lib/pgxs/src/makefiles/../../src/Makefile.shlib:292:<br>
&gt; instruction set for the target &quot;pgpool_adm.so&quot; failed<br>
&gt; make: *** [pgpool_adm.so] Error 1<br>
&gt; <br>
&gt; Thanks for any help!!<br>
&gt; 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&amp;d=DwICAg&amp;c=z7ZdhQWiOKyPuOPFlqJIyw&amp;r=EozxJ07eZdUti5lcY_lysVNm7ciSa1TsqyT6WzR_9a8&amp;m=8UVVRcJ0lrZ9dyh80rbG_ui9TmkKGqxbpb73nPjXsI4&amp;s=dDfWz6uxRZERF2g909S7ijMu-BdU5YyIM0BUhCSODlU&amp;e=" rel="noreferrer" target="_blank">https://urldefense.proofpoint.com/v2/url?u=http-3A__www.sraoss.co.jp_index-5Fen.php&amp;d=DwICAg&amp;c=z7ZdhQWiOKyPuOPFlqJIyw&amp;r=EozxJ07eZdUti5lcY_lysVNm7ciSa1TsqyT6WzR_9a8&amp;m=8UVVRcJ0lrZ9dyh80rbG_ui9TmkKGqxbpb73nPjXsI4&amp;s=dDfWz6uxRZERF2g909S7ijMu-BdU5YyIM0BUhCSODlU&amp;e=</a><br>
Japanese:<a href="https://urldefense.proofpoint.com/v2/url?u=http-3A__www.sraoss.co.jp&amp;d=DwICAg&amp;c=z7ZdhQWiOKyPuOPFlqJIyw&amp;r=EozxJ07eZdUti5lcY_lysVNm7ciSa1TsqyT6WzR_9a8&amp;m=8UVVRcJ0lrZ9dyh80rbG_ui9TmkKGqxbpb73nPjXsI4&amp;s=5a0EQrFGsXBVyWTw9_Fr7YI3uPnaI-fFWfPT9u3vkdA&amp;e=" rel="noreferrer" target="_blank">https://urldefense.proofpoint.com/v2/url?u=http-3A__www.sraoss.co.jp&amp;d=DwICAg&amp;c=z7ZdhQWiOKyPuOPFlqJIyw&amp;r=EozxJ07eZdUti5lcY_lysVNm7ciSa1TsqyT6WzR_9a8&amp;m=8UVVRcJ0lrZ9dyh80rbG_ui9TmkKGqxbpb73nPjXsI4&amp;s=5a0EQrFGsXBVyWTw9_Fr7YI3uPnaI-fFWfPT9u3vkdA&amp;e=</a><br>
</blockquote></div>