<div dir="ltr">Hi, all,<div><br></div><div>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. </div><div><br></div><div>postgres=# CREATE EXTENSION postgis;<br><b>ERROR:  could not load library "/usr/pgsql-12/lib/postgis-3.so": /lib64/libSFCGAL.so.1: undefined symbol: _ZN5boost7archive18text_iarchive_implINS0_13text_iarchiveEE4loadERSs</b><br>postgres=# <br></div><div><br></div><div>My system is centos 7. My packages and ldd are listed below. I appreciate if anyone can help! Thank you.</div><div><br></div><div>[CORP\dli@a-t14bdoo3y6xv ~]$ yum list installed | grep postgis<br>postgis31_12.x86_64                    3.1.1-3.rhel7                 @pgdg12    <br>[CORP\dli@a-t14bdoo3y6xv ~]$ yum list installed | grep postgresql12<br>postgresql12.x86_64                    12.6-1PGDG.rhel7              @pgdg12    <br>postgresql12-contrib.x86_64            12.6-1PGDG.rhel7              @pgdg12    <br>postgresql12-libs.x86_64               12.6-1PGDG.rhel7              @pgdg12    <br>postgresql12-server.x86_64             12.6-1PGDG.rhel7              @pgdg12    <br>[CORP\dli@a-t14bdoo3y6xv ~]$ yum list installed | grep proj<br>proj72.x86_64                          7.2.1-1.rhel7                 @rhel      <br>[CORP\dli@a-t14bdoo3y6xv ~]$ yum list installed | grep gdal<br>gdal32.x86_64                          3.2.2-15.rhel7                @rhel      <br>gdal32-libs.x86_64                     3.2.2-15.rhel7                @rhel      <br>[CORP\dli@a-t14bdoo3y6xv ~]$ yum list installed | grep geos<br>geos.x86_64                            3.4.2-2.el7                   @epel      <br>geos39.x86_64                          3.9.1-1.rhel7                 @rhel      <br>[CORP\dli@a-t14bdoo3y6xv ~]$ $ ldd /usr/pgsql-12/lib/postgis-3.so<br></div>       linux-vdso.so.1 (0x00007ffcbd4de000)<br>  libgeos_c.so.1 => /usr/geos39/lib64/libgeos_c.so.1 (0x00007f40de2ac000)<br>    libtiff.so.5 => /lib64/libtiff.so.5 (0x00007f40de03a000)<br>   libm.so.6 => /lib64/libm.so.6 (0x00007f40ddcfa000)<br> libproj.so.19 => /usr/proj72/lib/libproj.so.19 (0x00007f40dd7c4000)<br>        libjson-c.so.2 => /lib64/libjson-c.so.2 (0x00007f40dd5b9000)<br>       libxml2.so.2 => /lib64/libxml2.so.2 (0x00007f40dd260000)<br>   libz.so.1 => /lib64/libz.so.1 (0x00007f40dd04b000)<br> libdl.so.2 => /lib64/libdl.so.2 (0x00007f40dce47000)<br>       libSFCGAL.so.1 => /lib64/libSFCGAL.so.1 (0x00007f40dc384000)<br>       libc.so.6 => /lib64/libc.so.6 (0x00007f40dbfd9000)<br> <a href="http://libgeos-3.9.1.so">libgeos-3.9.1.so</a> => /usr/geos39/lib64/<a href="http://libgeos-3.9.1.so">libgeos-3.9.1.so</a> (0x00007f40dbbdb000)<br>        libstdc++.so.6 => /lib64/libstdc++.so.6 (0x00007f40db859000)<br>       libgcc_s.so.1 => /lib64/libgcc_s.so.1 (0x00007f40db643000)<br> libjbig.so.2.0 => /lib64/libjbig.so.2.0 (0x00007f40db437000)<br>       libjpeg.so.62 => /lib64/libjpeg.so.62 (0x00007f40db1e5000)<br> /lib64/ld-linux-x86-64.so.2 (0x00007f40de7e2000)<br>      libsqlite3.so.0 => /usr/sqlite330/lib/libsqlite3.so.0 (0x00007f40daed0000)<br> libcurl.so.4 => /lib64/libcurl.so.4 (0x00007f40dac4b000)<br>   libpthread.so.0 => /lib64/libpthread.so.0 (0x00007f40daa2d000)<br>     liblzma.so.5 => /lib64/liblzma.so.5 (0x00007f40da807000)<br>   libCGAL.so.11 => /usr/lib64/libCGAL.so.11 (0x00007f40da5df000)<br>     libCGAL_Core.so.11 => /usr/lib64/libCGAL_Core.so.11 (0x00007f40da3a6000)<br>   libmpfr.so.4 => /usr/lib64/libmpfr.so.4 (0x00007f40da148000)<br>       libgmp.so.10 => /usr/lib64/libgmp.so.10 (0x00007f40d9ed0000)<br>       libboost_date_time-mt.so.1.53.0 => /usr/lib64/libboost_date_time-mt.so.1.53.0 (0x00007f40d9cbf000)<br> libboost_thread-mt.so.1.53.0 => /usr/lib64/libboost_thread-mt.so.1.53.0 (0x00007f40d9a9d000)<br>       libboost_system-mt.so.1.53.0 => /usr/lib64/libboost_system-mt.so.1.53.0 (0x00007f40d9899000)<br>       libboost_serialization-mt.so.1.53.0 => /usr/lib64/libboost_serialization-mt.so.1.53.0 (0x00007f40d962c000)<br> libnghttp2.so.14 => /lib64/libnghttp2.so.14 (0x00007f40d9405000)<br>   libidn2.so.0 => /lib64/libidn2.so.0 (0x00007f40d91b6000)<br>   libssh2.so.1 => /lib64/libssh2.so.1 (0x00007f40d8f8e000)<br>   libssl.so.10 => /lib64/libssl.so.10 (0x00007f40d8d1f000)<br>   libcrypto.so.10 => /lib64/libcrypto.so.10 (0x00007f40d88ca000)<br>     libgssapi_krb5.so.2 => /lib64/libgssapi_krb5.so.2 (0x00007f40d867e000)<br>     libkrb5.so.3 => /lib64/libkrb5.so.3 (0x00007f40d839a000)<br>   libk5crypto.so.3 => /lib64/libk5crypto.so.3 (0x00007f40d8169000)<br>   libcom_err.so.2 => /lib64/libcom_err.so.2 (0x00007f40d7f65000)<br>     libldap-2.4.so.2 => /lib64/libldap-2.4.so.2 (0x00007f40d7d13000)<br>   liblber-2.4.so.2 => /lib64/liblber-2.4.so.2 (0x00007f40d7b04000)<br>   librt.so.1 => /usr/lib64/librt.so.1 (0x00007f40d78fc000)<br>   libunistring.so.0 => /lib64/libunistring.so.0 (0x00007f40d75e4000)<br> libkrb5support.so.0 => /lib64/libkrb5support.so.0 (0x00007f40d73d5000)<br>     libkeyutils.so.1 => /lib64/libkeyutils.so.1 (0x00007f40d71d1000)<br>   libresolv.so.2 => /lib64/libresolv.so.2 (0x00007f40d6fbb000)<br>       libsasl2.so.3 => /lib64/libsasl2.so.3 (0x00007f40d6d9e000)<br> libssl3.so => /lib64/libssl3.so (0x00007f40d6b44000)<br>       libsmime3.so => /lib64/libsmime3.so (0x00007f40d691e000)<br>   libnss3.so => /lib64/libnss3.so (0x00007f40d65f6000)<br>       libnssutil3.so => /lib64/libnssutil3.so (0x00007f40d63c7000)<br>       libplds4.so => /lib64/libplds4.so (0x00007f40d61c3000)<br>     libplc4.so => /lib64/libplc4.so (0x00007f40d5fbe000)<br>       libnspr4.so => /lib64/libnspr4.so (0x00007f40d5d82000)<br>     libselinux.so.1 => /lib64/libselinux.so.1 (0x00007f40d5b5b000)<br>     libcrypt.so.1 => /lib64/libcrypt.so.1 (0x00007f40d5924000)<br> libpcre.so.1 => /lib64/libpcre.so.1 (0x00007f40d56c0000)<br><div><br></div><div><br></div></div>