Re: EnterpriseDB installed PostgreSQL 9.6 vs. REPMGR. Round 4 - compilation issues on RHEL 7.2

On 15/05/2017 00:17, Martin Goodson wrote:

>
> Tomorrow I'll have to see about getting that set-up on an RHEL 7 box :)
>
> Thank you so much, everybody, for your help! It's been invaluable!
>
> Regards,
>
> Martin.
>

*Sigh*. And things were going so well. With Adrian and Devrim's help I
was able to get repmgr compiled on my little ubuntu box at home, and I
cheerfully went into work on Monday all ready to get things compiled nicely.

I forwarded Devrim's list of redhat/CentOS packages needed to my Unix
support colleagues, who installed the libraries listed. I've now got
nothing telling me such and such is missing. I now have this instead:

$ PATH=/db_demo/app/postgres/9.6.2-3/bin:$PATH make USE_PGXS=1 clean all
rm -f *.o
rm -f repmgrd
rm -f repmgr
make -C sql clean
make[1]: Entering directory `/home/pginst/repmgr-3.3.1/sql'

rm -f repmgr_funcs.so librepmgr_funcs.a librepmgr_funcs.pc
rm -f repmgr_funcs.sql
rm -f repmgr_funcs.o

make[1]: Leaving directory `/home/pginst/repmgr-3.3.1/sql'

gcc -Wall -Wmissing-prototypes -Wpointer-arith
-Wdeclaration-after-statement -Wendif-labels -Wmissing-format-attribute
-Wformat-security -fno-strict-aliasing -fwrapv -g -O2
-DMAP_HUGETLB=0x40000 -I/db_demo/app/postgres/9.6.2-3/include -I. -I./
-I/db_demo/app/postgres/9.6.2-3/include/postgresql/server
-I/db_demo/app/postgres/9.6.2-3/include/postgresql/internal
-D_GNU_SOURCE -I/opt/local/Current/include/libxml2
-I/opt/local/Current/include -c -o dbutils.o dbutils.c

gcc -Wall -Wmissing-prototypes -Wpointer-arith
-Wdeclaration-after-statement -Wendif-labels -Wmissing-format-attribute
-Wformat-security -fno-strict-aliasing -fwrapv -g -O2
-DMAP_HUGETLB=0x40000 -I/db_demo/app/postgres/9.6.2-3/include -I. -I./
-I/db_demo/app/postgres/9.6.2-3/include/postgresql/server
-I/db_demo/app/postgres/9.6.2-3/include/postgresql/internal
-D_GNU_SOURCE -I/opt/local/Current/include/libxml2
-I/opt/local/Current/include -c -o config.o config.c

gcc -Wall -Wmissing-prototypes -Wpointer-arith
-Wdeclaration-after-statement -Wendif-labels -Wmissing-format-attribute
-Wformat-security -fno-strict-aliasing -fwrapv -g -O2
-DMAP_HUGETLB=0x40000 -I/db_demo/app/postgres/9.6.2-3/include -I. -I./
-I/db_demo/app/postgres/9.6.2-3/include/postgresql/server
-I/db_demo/app/postgres/9.6.2-3/include/postgresql/internal
-D_GNU_SOURCE -I/opt/local/Current/include/libxml2
-I/opt/local/Current/include -c -o repmgrd.o repmgrd.c

gcc -Wall -Wmissing-prototypes -Wpointer-arith
-Wdeclaration-after-statement -Wendif-labels -Wmissing-format-attribute
-Wformat-security -fno-strict-aliasing -fwrapv -g -O2
-DMAP_HUGETLB=0x40000 -I/db_demo/app/postgres/9.6.2-3/include -I. -I./
-I/db_demo/app/postgres/9.6.2-3/include/postgresql/server
-I/db_demo/app/postgres/9.6.2-3/include/postgresql/internal
-D_GNU_SOURCE -I/opt/local/Current/include/libxml2
-I/opt/local/Current/include -c -o log.o log.c

gcc -Wall -Wmissing-prototypes -Wpointer-arith
-Wdeclaration-after-statement -Wendif-labels -Wmissing-format-attribute
-Wformat-security -fno-strict-aliasing -fwrapv -g -O2
-DMAP_HUGETLB=0x40000 -I/db_demo/app/postgres/9.6.2-3/include -I. -I./
-I/db_demo/app/postgres/9.6.2-3/include/postgresql/server
-I/db_demo/app/postgres/9.6.2-3/include/postgresql/internal
-D_GNU_SOURCE -I/opt/local/Current/include/libxml2
-I/opt/local/Current/include -c -o strutil.o strutil.c

gcc -o repmgrd -Wall -Wmissing-prototypes -Wpointer-arith
-Wdeclaration-after-statement -Wendif-labels -Wmissing-format-attribute
-Wformat-security -fno-strict-aliasing -fwrapv -g -O2
-DMAP_HUGETLB=0x40000 dbutils.o config.o repmgrd.o log.o strutil.o
-L/db_demo/app/postgres/9.6.2-3/lib -lpgcommon -lpgport
-L/db_demo/app/postgres/9.6.2-3/lib -lpq
-L/db_demo/app/postgres/9.6.2-3/lib -L/opt/local/Current/lib
-Wl,--as-needed
-Wl,-rpath,'/db_demo/app/postgres/9.6.2-3/lib',--enable-new-dtags
-lpgcommon -lpgport -lxslt -lxml2 -lpam -lssl -lcrypto -lgssapi_krb5 -lz
-ledit -lrt -lcrypt -ldl -lm

/bin/ld: warning: libssl.so.1.0.0, needed by
/db_demo/app/postgres/9.6.2-3/lib/libpq.so, may conflict with libssl.so.10

/lib64/libldap_r-2.4.so.2: undefined reference to `ber_sockbuf_io_udp'

I've forwarded that to our UNIX support team, just in case this is some
manner of known issue - and they've come back today saying, essentially,
we got nothing :)

FWIW, I'm trying this on a tiny virtual development server running RHEL
7.2 with 2 cpus and 4gb of RAM. PostgreSQL was built using the
EnterpriseDB installer and is in /db_demo/app/postgres/9.6.2-3.

Any ideas? Is this a new thing, an existing issue that's popped up
before, or (yet again! :) ) a case of me missing something that is
blindingly obvious to everyone else?

Regards,

Martin.
--
Martin Goodson

"Have you thought up some clever plan, Doctor?"
"Yes, Jamie, I believe I have."
"What're you going to do?"
"Bung a rock at it."