[postgis-users] Problem raster2pgsql on Centos 8 - postgres 12 / postgis
Alain Benard
alain.benard at inrae.fr
Fri Nov 6 01:53:50 PST 2020
From: "Regina Obe" <lr at pcorp.us<mailto:lr at 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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20201106/5c4de600/attachment.html>
More information about the postgis-users
mailing list