From: "Regina Obe" <l...@pcorp.us<mailto:l...@pcorp.us>>
Sounds from the below thread the issue is with proj and the interaction with GDAL. Can both of you let me know what the output of SELECT postgis_full_version() Gives - and also do an ldd raster2pgsql ldd postgis-2.5.so #probably need to specify full path There have been many changes in proj and while we patched it in for general postgis vector use in 3.0, 3.1+ Depending on you mix of GDAL version and Proj. Those 2 might be incompatible. GDAL < 3 should ideally be using a Proj < 6 GDAL > 3 should be using proj >= 6 and by extension so should PostGIS. Both PostGIS and GDAL should be using the same version of proj otherwise bad things happen. Hi, thank you Regina and Lars for your response. I would precise i did never compil any packet. Installation server history (Centos 8) : postgres : (https://www.postgresql.org/download/linux/redhat/) dnf -y install https://download.postgresql.org/pub/repos/yum/reporpms/EL-8-x86_64/pgdg-redhat-repo-latest.noarch.rpm dnf -qy module disable postgresql dnf -y install postgresql12-server postgresql12-devel postgresql12-contrib postgis : (https://computingforgeeks.com/how-to-install-postgis-on-centos-8-linux/) dnf -y install https://dl.fedoraproject.org/pub/epel/epel-release-latest-8.noarch.rpm dnf config-manager --set-enabled PowerTools dnf -y install postgis25_12 postgis25_12-docs postgis25_12-utils postgis25_12-client SELECT postgis_full_version() : POSTGIS="2.5.5" [EXTENSION] PGSQL="120" GEOS="3.8.1-CAPI-1.13.3" PROJ="Rel. 6.3.2, May 1st, 2020" GDAL="GDAL 3.1.3, released 2020/09/01" LIBXML="2.9.7" LIBJSON="0.13.1" LIBPROTOBUF="1.3.0" TOPOLOGY RASTER ldd /usr/pgsql-12/bin/raster2pgsql linux-vdso.so.1 (0x00007ffe013cb000) liblwgeom-2.5.so.0 => /usr/pgsql-12/lib/liblwgeom-2.5.so.0 (0x00007f222cedc000) libgdal.so.27 => /usr/gdal31/lib/libgdal.so.27 (0x00007f222b4f1000) libgeos_c.so.1 => /usr/geos38/lib64/libgeos_c.so.1 (0x00007f222b2b4000) libc.so.6 => /lib64/libc.so.6 (0x00007f222aef2000) libm.so.6 => /lib64/libm.so.6 (0x00007f222ab70000) libproj.so.19 => /usr/proj71/lib/libproj.so.19 (0x00007f222a65d000) libjson-c.so.4 => /lib64/libjson-c.so.4 (0x00007f222a44d000) libSFCGAL.so.1 => /lib64/libSFCGAL.so.1 (0x00007f2229756000) libarmadillo.so.9 => /lib64/libarmadillo.so.9 (0x00007f2229545000) libpoppler.so.78 => /lib64/libpoppler.so.78 (0x00007f222905f000) libfreexl.so.1 => /lib64/libfreexl.so.1 (0x00007f2228e55000) libwebp.so.7 => /lib64/libwebp.so.7 (0x00007f2228be7000) libodbc.so.2 => /lib64/libodbc.so.2 (0x00007f2228976000) libodbcinst.so.2 => /lib64/libodbcinst.so.2 (0x00007f2228760000) libexpat.so.1 => /lib64/libexpat.so.1 (0x00007f2228525000) libxerces-c-3.2.so => /lib64/libxerces-c-3.2.so (0x00007f2227f52000) libopenjp2.so.7 => /lib64/libopenjp2.so.7 (0x00007f2227d00000) libjasper.so.4 => /lib64/libjasper.so.4 (0x00007f2227aa2000) libnetcdf.so.15 => /lib64/libnetcdf.so.15 (0x00007f2227756000) libhdf5.so.103 => /lib64/libhdf5.so.103 (0x00007f22271cb000) libmfhdf.so.0 => /lib64/libmfhdf.so.0 (0x00007f2226fa2000) libdf.so.0 => /lib64/libdf.so.0 (0x00007f2226cf9000) libogdi.so.4 => /lib64/libogdi.so.4 (0x00007f2226adc000) libgif.so.7 => /lib64/libgif.so.7 (0x00007f22268d2000) libjpeg.so.62 => /lib64/libjpeg.so.62 (0x00007f2226669000) libgeotiff.so.5 => /lib64/libgeotiff.so.5 (0x00007f2226435000) libtiff.so.5 => /lib64/libtiff.so.5 (0x00007f22261bc000) libgta.so.1 => /lib64/libgta.so.1 (0x00007f2225fb2000) libpng16.so.16 => /lib64/libpng16.so.16 (0x00007f2225d7d000) libcfitsio.so.7 => /lib64/libcfitsio.so.7 (0x00007f2225872000) libpq.so.5 => /usr/pgsql-12/lib/libpq.so.5 (0x00007f2225623000) libzstd.so.1 => /lib64/libzstd.so.1 (0x00007f2225381000) liblzma.so.5 => /lib64/liblzma.so.5 (0x00007f222515a000) libproj.so.15 => /lib64/libproj.so.15 (0x00007f2224c4a000) libsqlite3.so.0 => /lib64/libsqlite3.so.0 (0x00007f2224937000) librt.so.1 => /lib64/librt.so.1 (0x00007f222472e000) libtirpc.so.3 => /lib64/libtirpc.so.3 (0x00007f22244fb000) libdapclient.so.6 => /lib64/libdapclient.so.6 (0x00007f22242b1000) libdapserver.so.7 => /lib64/libdapserver.so.7 (0x00007f22240a0000) libdap.so.25 => /lib64/libdap.so.25 (0x00007f2223ce4000) libspatialite.so.7 => /lib64/libspatialite.so.7 (0x00007f22234a9000) libpcre.so.1 => /lib64/libpcre.so.1 (0x00007f2223238000) libcurl.so.4 => /lib64/libcurl.so.4 (0x00007f2222faa000) libxml2.so.2 => /lib64/libxml2.so.2 (0x00007f2222c42000) libmariadb.so.3 => /lib64/libmariadb.so.3 (0x00007f22229f0000) libz.so.1 => /lib64/libz.so.1 (0x00007f22227d9000) libdl.so.2 => /lib64/libdl.so.2 (0x00007f22225d5000) libpthread.so.0 => /lib64/libpthread.so.0 (0x00007f22223b5000) libssl.so.1.1 => /lib64/libssl.so.1.1 (0x00007f2222121000) libcrypto.so.1.1 => /lib64/libcrypto.so.1.1 (0x00007f2221c3e000) libstdc++.so.6 => /lib64/libstdc++.so.6 (0x00007f22218a9000) /lib64/ld-linux-x86-64.so.2 (0x00007f222d184000) libgcc_s.so.1 => /lib64/libgcc_s.so.1 (0x00007f2221691000) libgeos-3.8.1.so => /usr/geos38/lib64/libgeos-3.8.1.so (0x00007f22212bc000) libCGAL_Core.so.13 => /usr/lib64/libCGAL_Core.so.13 (0x00007f222101c000) libboost_thread.so.1.66.0 => /usr/lib64/libboost_thread.so.1.66.0 (0x00007f2220df0000) libboost_system.so.1.66.0 => /usr/lib64/libboost_system.so.1.66.0 (0x00007f2220beb000) libboost_serialization.so.1.66.0 => /usr/lib64/libboost_serialization.so.1.66.0 (0x00007f22209aa000) libboost_chrono.so.1.66.0 => /usr/lib64/libboost_chrono.so.1.66.0 (0x00007f22207a1000) libboost_date_time.so.1.66.0 => /usr/lib64/libboost_date_time.so.1.66.0 (0x00007f222058e000) libboost_atomic.so.1.66.0 => /usr/lib64/libboost_atomic.so.1.66.0 (0x00007f222038c000) libCGAL.so.13 => /usr/lib64/libCGAL.so.13 (0x00007f222016d000) libmpfr.so.4 => /usr/lib64/libmpfr.so.4 (0x00007f221ff09000) libgmp.so.10 => /usr/lib64/libgmp.so.10 (0x00007f221fc71000) libopenblaso.so.0 => /lib64/libopenblaso.so.0 (0x00007f221df27000) liblapack.so.3 => /lib64/liblapack.so.3 (0x00007f221d686000) libsz.so.2 => /lib64/libsz.so.2 (0x00007f221d483000) libarpack.so.2 => /lib64/libarpack.so.2 (0x00007f221d235000) libsuperlu.so.5.1 => /lib64/libsuperlu.so.5.1 (0x00007f221cfbf000) libfreetype.so.6 => /lib64/libfreetype.so.6 (0x00007f221cd03000) libfontconfig.so.1 => /lib64/libfontconfig.so.1 (0x00007f221cabe000) libsmime3.so => /lib64/libsmime3.so (0x00007f221c895000) libnss3.so => /lib64/libnss3.so (0x00007f221c55f000) libnspr4.so => /lib64/libnspr4.so (0x00007f221c31e000) liblcms2.so.2 => /lib64/liblcms2.so.2 (0x00007f221c0c1000) libltdl.so.7 => /lib64/libltdl.so.7 (0x00007f221beb7000) libhdf5_hl.so.100 => /lib64/libhdf5_hl.so.100 (0x00007f221bc93000) libjbig.so.2.1 => /lib64/libjbig.so.2.1 (0x00007f221ba87000) libbz2.so.1 => /lib64/libbz2.so.1 (0x00007f221b876000) libgssapi_krb5.so.2 => /lib64/libgssapi_krb5.so.2 (0x00007f221b626000) libldap_r-2.4.so.2 => /lib64/libldap_r-2.4.so.2 (0x00007f221b3d0000) libkrb5.so.3 => /lib64/libkrb5.so.3 (0x00007f221b0e0000) libk5crypto.so.3 => /lib64/libk5crypto.so.3 (0x00007f221aec4000) libcom_err.so.2 => /lib64/libcom_err.so.2 (0x00007f221acc0000) libuuid.so.1 => /lib64/libuuid.so.1 (0x00007f221aab8000) libnghttp2.so.14 => /lib64/libnghttp2.so.14 (0x00007f221a891000) libidn2.so.0 => /lib64/libidn2.so.0 (0x00007f221a673000) libssh.so.4 => /lib64/libssh.so.4 (0x00007f221a3e8000) libpsl.so.5 => /lib64/libpsl.so.5 (0x00007f221a1d7000) libldap-2.4.so.2 => /lib64/libldap-2.4.so.2 (0x00007f2219f8a000) liblber-2.4.so.2 => /lib64/liblber-2.4.so.2 (0x00007f2219d7a000) libbrotlidec.so.1 => /lib64/libbrotlidec.so.1 (0x00007f2219b6e000) libgfortran.so.5 => /lib64/libgfortran.so.5 (0x00007f22196f1000) libgomp.so.1 => /lib64/libgomp.so.1 (0x00007f22194b9000) libblas.so.3 => /lib64/libblas.so.3 (0x00007f2219265000) libaec.so.0 => /lib64/libaec.so.0 (0x00007f221905d000) libopenblasp.so.0 => /lib64/libopenblasp.so.0 (0x00007f2217312000) libquadmath.so.0 => /lib64/libquadmath.so.0 (0x00007f22170d1000) libsatlas.so.3 => /usr/lib64/atlas/libsatlas.so.3 (0x00007f22162f6000) libnssutil3.so => /lib64/libnssutil3.so (0x00007f22160c5000) libplc4.so => /lib64/libplc4.so (0x00007f2215ec0000) libplds4.so => /lib64/libplds4.so (0x00007f2215cbc000) libkrb5support.so.0 => /lib64/libkrb5support.so.0 (0x00007f2215aab000) libkeyutils.so.1 => /lib64/libkeyutils.so.1 (0x00007f22158a7000) libresolv.so.2 => /lib64/libresolv.so.2 (0x00007f2215690000) libsasl2.so.3 => /lib64/libsasl2.so.3 (0x00007f2215472000) libunistring.so.2 => /lib64/libunistring.so.2 (0x00007f22150f1000) libbrotlicommon.so.1 => /lib64/libbrotlicommon.so.1 (0x00007f2214ed1000) libselinux.so.1 => /lib64/libselinux.so.1 (0x00007f2214ca6000) libcrypt.so.1 => /lib64/libcrypt.so.1 (0x00007f2214a7d000) libpcre2-8.so.0 => /lib64/libpcre2-8.so.0 (0x00007f22147f9000) ldd /usr/pgsql-12/lib/postgis-2.5.so linux-vdso.so.1 (0x00007fff426f6000) libgeos_c.so.1 => /usr/geos38/lib64/libgeos_c.so.1 (0x00007f9c081b7000) libproj.so.15 => /lib64/libproj.so.15 (0x00007f9c07ca7000) libjson-c.so.4 => /lib64/libjson-c.so.4 (0x00007f9c07a97000) libprotobuf-c.so.1 => /lib64/libprotobuf-c.so.1 (0x00007f9c0788e000) libxml2.so.2 => /lib64/libxml2.so.2 (0x00007f9c07526000) libm.so.6 => /lib64/libm.so.6 (0x00007f9c071a4000) libSFCGAL.so.1 => /lib64/libSFCGAL.so.1 (0x00007f9c064ad000) libc.so.6 => /lib64/libc.so.6 (0x00007f9c060eb000) libgeos-3.8.1.so => /usr/geos38/lib64/libgeos-3.8.1.so (0x00007f9c05d16000) libstdc++.so.6 => /lib64/libstdc++.so.6 (0x00007f9c05981000) libgcc_s.so.1 => /lib64/libgcc_s.so.1 (0x00007f9c05769000) libsqlite3.so.0 => /lib64/libsqlite3.so.0 (0x00007f9c05456000) libpthread.so.0 => /lib64/libpthread.so.0 (0x00007f9c05236000) /lib64/ld-linux-x86-64.so.2 (0x00007f9c086e0000) libdl.so.2 => /lib64/libdl.so.2 (0x00007f9c05032000) libz.so.1 => /lib64/libz.so.1 (0x00007f9c04e1b000) liblzma.so.5 => /lib64/liblzma.so.5 (0x00007f9c04bf4000) libCGAL_Core.so.13 => /usr/lib64/libCGAL_Core.so.13 (0x00007f9c04954000) libboost_thread.so.1.66.0 => /usr/lib64/libboost_thread.so.1.66.0 (0x00007f9c04728000) libboost_system.so.1.66.0 => /usr/lib64/libboost_system.so.1.66.0 (0x00007f9c04523000) libboost_serialization.so.1.66.0 => /usr/lib64/libboost_serialization.so.1.66.0 (0x00007f9c042e2000) libboost_chrono.so.1.66.0 => /usr/lib64/libboost_chrono.so.1.66.0 (0x00007f9c040d9000) libboost_date_time.so.1.66.0 => /usr/lib64/libboost_date_time.so.1.66.0 (0x00007f9c03ec6000) libboost_atomic.so.1.66.0 => /usr/lib64/libboost_atomic.so.1.66.0 (0x00007f9c03cc4000) libCGAL.so.13 => /usr/lib64/libCGAL.so.13 (0x00007f9c03aa5000) libmpfr.so.4 => /usr/lib64/libmpfr.so.4 (0x00007f9c03841000) libgmp.so.10 => /usr/lib64/libgmp.so.10 (0x00007f9c035a9000) librt.so.1 => /usr/lib64/librt.so.1 (0x00007f9c033a0000) I can precise that recently (after dnf upgrade) we need to downgrade gdal31-libs-3.1.3-2.rhel8.x86_64 to gdal31-libs-3.1.3-1.rhel8.x86_64. The raison was postgis_full_version return error Message : ERROR: could not load library "/usr/pgsql-12/lib/rtpostgis-2.5.so": /usr/gdal31/lib/libgdal.so.27: undefined symbol: GTIFGetGCSInfoEx I can precise dnf list installed | grep gdal show : gdal30-libs.x86_64 3.0.4-4.rhel8 @pgdg-common gdal31-libs.x86_64 3.1.3-1.rhel8 @pgdg-common Have a nice day and thanks for your help. Alain.
_______________________________________________ postgis-users mailing list postgis-users@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/postgis-users