[pgpool-general: 6268] Re: Error compiling pgpool_adm on debian 9.5 (impossible to find -lpcp)

[Tatsuo Ishii]

> Hi,
> 
> no, I didn't.
> My original idea was to install pgpool in a different server than
> postgresql, so I didn't.
> 
> Now, with pgpool installed in the postgresql server, pgpool_adm can be
> installed.
> 
> 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).

Although it's up to your decision, you could go on with the initial
design, because actually what pgpool_adm extension needs is only
libpcp, and you don't need to start pgpool server on the server which
pgpool_adm is installed.

> Anyway, thank you very much!!

You are welcome!

> Matteo M.
> 
> Il giorno gio 8 nov 2018 alle ore 05:54 Tatsuo Ishii <ishii at sraoss.co.jp>
> ha scritto:
> 
>> Hi Matteo,
>>
>> > Hi all,
>> >
>> > I can't compile pgpool_adm (pgpool 4.0.0, but also with 4.0.1 I found the
>> > same error) on debian 9.5.
>> > My server has postgresql 10.5 installed on a fresh new installation of
>> > debian.
>> >
>> > Over the fresh machine I installed (after reading lot of guides) these
>> > packages:
>> > sudo
>> > make
>> > gcc
>> > libpq-dev
>> > postgresql-10
>> > postgresql-server-dev-10
>> >
>> > My pgpool installation is on a different server.
>> >
>> > but the make command fails as below (maybe I still miss some packages).
>> > (With the same server I can successfully make pgpool-recovery)
>> >
>> > Here the output:
>> > root at debian-server:/home/user/Scaricati# cd pgpool-II-4.0.0
>> > root at debian-server:/home/user/Scaricati/pgpool-II-4.0.0# cd
>> > src/sql/pgpool_adm/
>> > root at debian-server
>> :/home/user/Scaricati/pgpool-II-4.0.0/src/sql/pgpool_adm#
>> > make
>> > gcc -Wall -Wmissing-prototypes -Wpointer-arith
>> > -Wdeclaration-after-statement -Wendif-labels -Wmissing-format-attribute
>> > -Wformat-security -fno-strict-aliasing -fwrapv
>> -fexcess-precision=standard
>> > -g -g -O2 -fstack-protector-strong -Wformat -Werror=format-security
>> > -fno-omit-frame-pointer -fPIC -I/usr/include/postgresql
>> -I../../include/pcp
>> > -I. -I./ -I/usr/include/postgresql/10/server
>> > -I/usr/include/postgresql/internal  -Wdate-time -D_FORTIFY_SOURCE=2
>> > -D_GNU_SOURCE -I/usr/include/libxml2  -I/usr/include/mit-krb5  -c -o
>> > pgpool_adm.o pgpool_adm.c
>> > gcc -Wall -Wmissing-prototypes -Wpointer-arith
>> > -Wdeclaration-after-statement -Wendif-labels -Wmissing-format-attribute
>> > -Wformat-security -fno-strict-aliasing -fwrapv
>> -fexcess-precision=standard
>> > -g -g -O2 -fstack-protector-strong -Wformat -Werror=format-security
>> > -fno-omit-frame-pointer -fPIC -shared -o pgpool_adm.so pgpool_adm.o
>> > -L/usr/lib/x86_64-linux-gnu  -Wl,-z,relro -Wl,-z,now
>> > -L/usr/lib/x86_64-linux-gnu/mit-krb5 -Wl,--as-needed
>> > -L../../libs/pcp/.libs -lpcp -Wl,--as-needed
>> > -Wl,-rpath,'/lib',--enable-new-dtags
>> > /usr/bin/ld: impossibile trovare -lpcp
>> > collect2: error: ld returned 1 exit status
>> >
>> /usr/lib/postgresql/10/lib/pgxs/src/makefiles/../../src/Makefile.shlib:292:
>> > set di istruzioni per l'obiettivo "pgpool_adm.so" non riuscito
>> > make: *** [pgpool_adm.so] Errore 1
>> >
>> > The error is (here the translation)
>> > /usr/bin/ld: impossible to find -lpcp
>> > collect2: error: ld returned 1 exit status
>> >
>> /usr/lib/postgresql/10/lib/pgxs/src/makefiles/../../src/Makefile.shlib:292:
>> > instruction set for the target "pgpool_adm.so" failed
>> > make: *** [pgpool_adm.so] Error 1
>> >
>> > Thanks for any help!!
>> > Matteo M.
>>
>> You need to install libpcp first. libpcp comes with Pgpool-II
>> itself. Have you installed Pgpool-II (except pgpool_adm)?
>>
>> Best regards,
>> --
>> Tatsuo Ishii
>> SRA OSS, Inc. Japan
>> English:
>> 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=
>> Japanese:
>> 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=
>>