[postgis-users] /lib64/libSFCGAL.so.1: undefined symbol error

[Andy Johnson]

Hi, all,

I'm trying to install postgresql 12 with postgis31_12. I've successfully
installed everything, but got an error message when I tried to create the
extension postgis.

postgres=# CREATE EXTENSION postgis;
*ERROR:  could not load library "/usr/pgsql-12/lib/postgis-3.so":
/lib64/libSFCGAL.so.1: undefined symbol:
_ZN5boost7archive18text_iarchive_implINS0_13text_iarchiveEE4loadERSs*
postgres=#

My system is centos 7. My packages and ldd are listed below. I
appreciate if anyone can help! Thank you.

[CORP\dli at a-t14bdoo3y6xv ~]$ yum list installed | grep postgis
postgis31_12.x86_64                    3.1.1-3.rhel7
@pgdg12
[CORP\dli at a-t14bdoo3y6xv ~]$ yum list installed | grep postgresql12
postgresql12.x86_64                    12.6-1PGDG.rhel7
 @pgdg12
postgresql12-contrib.x86_64            12.6-1PGDG.rhel7
 @pgdg12
postgresql12-libs.x86_64               12.6-1PGDG.rhel7
 @pgdg12
postgresql12-server.x86_64             12.6-1PGDG.rhel7
 @pgdg12
[CORP\dli at a-t14bdoo3y6xv ~]$ yum list installed | grep proj
proj72.x86_64                          7.2.1-1.rhel7                 @rhel

[CORP\dli at a-t14bdoo3y6xv ~]$ yum list installed | grep gdal
gdal32.x86_64                          3.2.2-15.rhel7                @rhel

gdal32-libs.x86_64                     3.2.2-15.rhel7                @rhel

[CORP\dli at a-t14bdoo3y6xv ~]$ yum list installed | grep geos
geos.x86_64                            3.4.2-2.el7                   @epel

geos39.x86_64                          3.9.1-1.rhel7                 @rhel

[CORP\dli at a-t14bdoo3y6xv ~]$ $ ldd /usr/pgsql-12/lib/postgis-3.so
linux-vdso.so.1 (0x00007ffcbd4de000)
libgeos_c.so.1 => /usr/geos39/lib64/libgeos_c.so.1 (0x00007f40de2ac000)
libtiff.so.5 => /lib64/libtiff.so.5 (0x00007f40de03a000)
libm.so.6 => /lib64/libm.so.6 (0x00007f40ddcfa000)
libproj.so.19 => /usr/proj72/lib/libproj.so.19 (0x00007f40dd7c4000)
libjson-c.so.2 => /lib64/libjson-c.so.2 (0x00007f40dd5b9000)
libxml2.so.2 => /lib64/libxml2.so.2 (0x00007f40dd260000)
libz.so.1 => /lib64/libz.so.1 (0x00007f40dd04b000)
libdl.so.2 => /lib64/libdl.so.2 (0x00007f40dce47000)
libSFCGAL.so.1 => /lib64/libSFCGAL.so.1 (0x00007f40dc384000)
libc.so.6 => /lib64/libc.so.6 (0x00007f40dbfd9000)
libgeos-3.9.1.so => /usr/geos39/lib64/libgeos-3.9.1.so (0x00007f40dbbdb000)
libstdc++.so.6 => /lib64/libstdc++.so.6 (0x00007f40db859000)
libgcc_s.so.1 => /lib64/libgcc_s.so.1 (0x00007f40db643000)
libjbig.so.2.0 => /lib64/libjbig.so.2.0 (0x00007f40db437000)
libjpeg.so.62 => /lib64/libjpeg.so.62 (0x00007f40db1e5000)
/lib64/ld-linux-x86-64.so.2 (0x00007f40de7e2000)
libsqlite3.so.0 => /usr/sqlite330/lib/libsqlite3.so.0 (0x00007f40daed0000)
libcurl.so.4 => /lib64/libcurl.so.4 (0x00007f40dac4b000)
libpthread.so.0 => /lib64/libpthread.so.0 (0x00007f40daa2d000)
liblzma.so.5 => /lib64/liblzma.so.5 (0x00007f40da807000)
libCGAL.so.11 => /usr/lib64/libCGAL.so.11 (0x00007f40da5df000)
libCGAL_Core.so.11 => /usr/lib64/libCGAL_Core.so.11 (0x00007f40da3a6000)
libmpfr.so.4 => /usr/lib64/libmpfr.so.4 (0x00007f40da148000)
libgmp.so.10 => /usr/lib64/libgmp.so.10 (0x00007f40d9ed0000)
libboost_date_time-mt.so.1.53.0 =>
/usr/lib64/libboost_date_time-mt.so.1.53.0 (0x00007f40d9cbf000)
libboost_thread-mt.so.1.53.0 => /usr/lib64/libboost_thread-mt.so.1.53.0
(0x00007f40d9a9d000)
libboost_system-mt.so.1.53.0 => /usr/lib64/libboost_system-mt.so.1.53.0
(0x00007f40d9899000)
libboost_serialization-mt.so.1.53.0 =>
/usr/lib64/libboost_serialization-mt.so.1.53.0 (0x00007f40d962c000)
libnghttp2.so.14 => /lib64/libnghttp2.so.14 (0x00007f40d9405000)
libidn2.so.0 => /lib64/libidn2.so.0 (0x00007f40d91b6000)
libssh2.so.1 => /lib64/libssh2.so.1 (0x00007f40d8f8e000)
libssl.so.10 => /lib64/libssl.so.10 (0x00007f40d8d1f000)
libcrypto.so.10 => /lib64/libcrypto.so.10 (0x00007f40d88ca000)
libgssapi_krb5.so.2 => /lib64/libgssapi_krb5.so.2 (0x00007f40d867e000)
libkrb5.so.3 => /lib64/libkrb5.so.3 (0x00007f40d839a000)
libk5crypto.so.3 => /lib64/libk5crypto.so.3 (0x00007f40d8169000)
libcom_err.so.2 => /lib64/libcom_err.so.2 (0x00007f40d7f65000)
libldap-2.4.so.2 => /lib64/libldap-2.4.so.2 (0x00007f40d7d13000)
liblber-2.4.so.2 => /lib64/liblber-2.4.so.2 (0x00007f40d7b04000)
librt.so.1 => /usr/lib64/librt.so.1 (0x00007f40d78fc000)
libunistring.so.0 => /lib64/libunistring.so.0 (0x00007f40d75e4000)
libkrb5support.so.0 => /lib64/libkrb5support.so.0 (0x00007f40d73d5000)
libkeyutils.so.1 => /lib64/libkeyutils.so.1 (0x00007f40d71d1000)
libresolv.so.2 => /lib64/libresolv.so.2 (0x00007f40d6fbb000)
libsasl2.so.3 => /lib64/libsasl2.so.3 (0x00007f40d6d9e000)
libssl3.so => /lib64/libssl3.so (0x00007f40d6b44000)
libsmime3.so => /lib64/libsmime3.so (0x00007f40d691e000)
libnss3.so => /lib64/libnss3.so (0x00007f40d65f6000)
libnssutil3.so => /lib64/libnssutil3.so (0x00007f40d63c7000)
libplds4.so => /lib64/libplds4.so (0x00007f40d61c3000)
libplc4.so => /lib64/libplc4.so (0x00007f40d5fbe000)
libnspr4.so => /lib64/libnspr4.so (0x00007f40d5d82000)
libselinux.so.1 => /lib64/libselinux.so.1 (0x00007f40d5b5b000)
libcrypt.so.1 => /lib64/libcrypt.so.1 (0x00007f40d5924000)
libpcre.so.1 => /lib64/libpcre.so.1 (0x00007f40d56c0000)
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20210507/63d4a9c2/attachment.html>