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

[Saulteau Don]

That usually means that sfcgal needs a rebuild. One of its dependencies got
upgraded and needs to be built against it.

On Fri., May 7, 2021, 21:20 Andy Johnson, <atudfw168 at gmail.com> wrote:

> 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)
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20210510/27d14bc4/attachment.html>