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

Martin Goodson <kaemaril@xxxxxxxxxxxxxx> · Tue, 16 May 2017 12:36:13 +0100



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