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

[Matteo Monesi]

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).

Anyway, thank you very much!!
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=
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20181108/4971b118/attachment.html>