From: "Regina Obe" <[email protected]<mailto:[email protected]>>
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
[email protected]
https://lists.osgeo.org/mailman/listinfo/postgis-users
