[postgis-users] Problem raster2pgsql on Centos 8 - postgres 12 / postgis 2.5

Thu Nov 5 01:44:35 PST 2020

Hi Lars,

I would start by removing the old libproj.so.15. You still have an old
PROJ lib around.

Good luck,

Jorge Gustavo

Às 05:55 de 05/11/20, Lars Aksel Opsahl escreveu:
>>
>>
>>From: postgis-users <postgis-users-bounces at lists.osgeo.org> on behalf
> of Regina Obe <lr at pcorp.us>Sent: Wednesday, November 4, 2020 11:05 PMTo:
> 'PostGIS Users Discussion' <postgis-users at lists.osgeo.org>Subject: Re:
> [postgis-users] Problem raster2pgsql on Centos 8 - postgres 12 / postgis 2.5
>>
>>
>>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()l
>>
> 
> POSTGIS="3.1.0dev 3.1.0alpha2-100-g50b1e70b1" [EXTENSION] PGSQL="120"
> GEOS="3.8.1-CAPI-1.13.3" SFCGAL="1.3.7" PROJ="7.1.1" GDAL="GDAL 3.1.3,
> released 2020/09/01" LIBXML="2.9.7" LIBJSON="0.13.1"
>  LIBPROTOBUF="1.3.0" WAGYU="0.5.0 (Internal)" TOPOLOGY RASTER
>>
>>
>>Gives – and also do an
>>
>>
>>
>>ldd raster2pgsql
>>
> 
> ldd /usr/pgsql-12/bin/raster2pgsql
> linux-vdso.so.1 (0x00007fffee50b000)
> libm.so.6 => /lib64/libm.so.6 (0x00007fb9a42f0000)
> libproj.so.19 => /usr/proj71/lib/libproj.so.19 (0x00007fb9a3ddd000)
> libsqlite3.so.0 => /lib64/libsqlite3.so.0 (0x00007fb9a3aca000)
> libtiff.so.5 => /lib64/libtiff.so.5 (0x00007fb9a3851000)
> libcurl.so.4 => /lib64/libcurl.so.4 (0x00007fb9a35c3000)
> libpthread.so.0 => /lib64/libpthread.so.0 (0x00007fb9a33a3000)
> libdl.so.2 => /lib64/libdl.so.2 (0x00007fb9a319f000)
> libjson-c.so.4 => /lib64/libjson-c.so.4 (0x00007fb9a2f8f000)
> libSFCGAL.so.1 => /lib64/libSFCGAL.so.1 (0x00007fb9a2298000)
> libgdal.so.27 => /usr/gdal31/lib/libgdal.so.27 (0x00007fb9a08ad000)
> libgeos_c.so.1 => /usr/geos38/lib64/libgeos_c.so.1 (0x00007fb9a0670000)
> libc.so.6 => /lib64/libc.so.6 (0x00007fb9a02ae000)
> /lib64/ld-linux-x86-64.so.2 (0x00007fb9a4672000)
> libstdc++.so.6 => /lib64/libstdc++.so.6 (0x00007fb99ff19000)
> libgcc_s.so.1 => /lib64/libgcc_s.so.1 (0x00007fb99fd01000)
> libz.so.1 => /lib64/libz.so.1 (0x00007fb99faea000)
> libjbig.so.2.1 => /lib64/libjbig.so.2.1 (0x00007fb99f8de000)
> libjpeg.so.62 => /lib64/libjpeg.so.62 (0x00007fb99f675000)
> libnghttp2.so.14 => /lib64/libnghttp2.so.14 (0x00007fb99f44e000)
> libidn2.so.0 => /lib64/libidn2.so.0 (0x00007fb99f230000)
> libssh.so.4 => /lib64/libssh.so.4 (0x00007fb99efa5000)
> libpsl.so.5 => /lib64/libpsl.so.5 (0x00007fb99ed94000)
> libssl.so.1.1 => /lib64/libssl.so.1.1 (0x00007fb99eb00000)
> libcrypto.so.1.1 => /lib64/libcrypto.so.1.1 (0x00007fb99e61d000)
> libgssapi_krb5.so.2 => /lib64/libgssapi_krb5.so.2 (0x00007fb99e3cd000)
> libkrb5.so.3 => /lib64/libkrb5.so.3 (0x00007fb99e0dd000)
> libk5crypto.so.3 => /lib64/libk5crypto.so.3 (0x00007fb99dec1000)
> libcom_err.so.2 => /lib64/libcom_err.so.2 (0x00007fb99dcbd000)
> libldap-2.4.so.2 => /lib64/libldap-2.4.so.2 (0x00007fb99da70000)
> liblber-2.4.so.2 => /lib64/liblber-2.4.so.2 (0x00007fb99d860000)
> libbrotlidec.so.1 => /lib64/libbrotlidec.so.1 (0x00007fb99d654000)
> libCGAL_Core.so.13 => /usr/lib64/libCGAL_Core.so.13 (0x00007fb99d3b4000)
> libboost_thread.so.1.66.0 => /usr/lib64/libboost_thread.so.1.66.0
> (0x00007fb99d188000)
> libboost_system.so.1.66.0 => /usr/lib64/libboost_system.so.1.66.0
> (0x00007fb99cf83000)
> libboost_serialization.so.1.66.0 =>
> /usr/lib64/libboost_serialization.so.1.66.0 (0x00007fb99cd42000)
> libboost_chrono.so.1.66.0 => /usr/lib64/libboost_chrono.so.1.66.0
> (0x00007fb99cb39000)
> libboost_date_time.so.1.66.0 => /usr/lib64/libboost_date_time.so.1.66.0
> (0x00007fb99c926000)
> libboost_atomic.so.1.66.0 => /usr/lib64/libboost_atomic.so.1.66.0
> (0x00007fb99c724000)
> libCGAL.so.13 => /usr/lib64/libCGAL.so.13 (0x00007fb99c505000)
> libmpfr.so.4 => /usr/lib64/libmpfr.so.4 (0x00007fb99c2a1000)
> libgmp.so.10 => /usr/lib64/libgmp.so.10 (0x00007fb99c009000)
> libarmadillo.so.9 => /lib64/libarmadillo.so.9 (0x00007fb99bdf8000)
> libpoppler.so.78 => /lib64/libpoppler.so.78 (0x00007fb99b912000)
> libfreexl.so.1 => /lib64/libfreexl.so.1 (0x00007fb99b708000)
> libwebp.so.7 => /lib64/libwebp.so.7 (0x00007fb99b49a000)
> libodbc.so.2 => /lib64/libodbc.so.2 (0x00007fb99b229000)
> libodbcinst.so.2 => /lib64/libodbcinst.so.2 (0x00007fb99b013000)
> libexpat.so.1 => /lib64/libexpat.so.1 (0x00007fb99add8000)
> libxerces-c-3.2.so => /lib64/libxerces-c-3.2.so (0x00007fb99a805000)
> libopenjp2.so.7 => /lib64/libopenjp2.so.7 (0x00007fb99a5b3000)
> libjasper.so.4 => /lib64/libjasper.so.4 (0x00007fb99a355000)
> libnetcdf.so.15 => /lib64/libnetcdf.so.15 (0x00007fb99a009000)
> libhdf5.so.103 => /lib64/libhdf5.so.103 (0x00007fb999a7e000)
> libmfhdf.so.0 => /lib64/libmfhdf.so.0 (0x00007fb999855000)
> libdf.so.0 => /lib64/libdf.so.0 (0x00007fb9995ac000)
> libogdi.so.4 => /lib64/libogdi.so.4 (0x00007fb99938f000)
> libgif.so.7 => /lib64/libgif.so.7 (0x00007fb999185000)
> libgeotiff.so.5 => /usr/libgeotiff16/lib/libgeotiff.so.5
> (0x00007fb998f52000)
> libgta.so.1 => /lib64/libgta.so.1 (0x00007fb998d48000)
> libpng16.so.16 => /lib64/libpng16.so.16 (0x00007fb998b13000)
> libcfitsio.so.7 => /lib64/libcfitsio.so.7 (0x00007fb998608000)
> libpq.so.5 => /lib64/libpq.so.5 (0x00007fb9983b7000)
> libzstd.so.1 => /lib64/libzstd.so.1 (0x00007fb998115000)
> liblzma.so.5 => /lib64/liblzma.so.5 (0x00007fb997eee000)
> libproj.so.15 => /lib64/libproj.so.15 (0x00007fb9979de000)
> librt.so.1 => /lib64/librt.so.1 (0x00007fb9977d5000)
> libtirpc.so.3 => /lib64/libtirpc.so.3 (0x00007fb9975a2000)
> libdapclient.so.6 => /lib64/libdapclient.so.6 (0x00007fb997358000)
> libdapserver.so.7 => /lib64/libdapserver.so.7 (0x00007fb997147000)
> libdap.so.25 => /lib64/libdap.so.25 (0x00007fb996d8b000)
> libspatialite.so.7 => /lib64/libspatialite.so.7 (0x00007fb996550000)
> libpcre.so.1 => /lib64/libpcre.so.1 (0x00007fb9962df000)
> libxml2.so.2 => /lib64/libxml2.so.2 (0x00007fb995f77000)
> libmariadb.so.3 => /lib64/libmariadb.so.3 (0x00007fb995d25000)
> libgeos-3.8.1.so => /usr/geos38/lib64/libgeos-3.8.1.so (0x00007fb995950000)
> libunistring.so.2 => /lib64/libunistring.so.2 (0x00007fb9955cf000)
> libkrb5support.so.0 => /lib64/libkrb5support.so.0 (0x00007fb9953be000)
> libkeyutils.so.1 => /lib64/libkeyutils.so.1 (0x00007fb9951ba000)
> libresolv.so.2 => /lib64/libresolv.so.2 (0x00007fb994fa3000)
> libsasl2.so.3 => /lib64/libsasl2.so.3 (0x00007fb994d85000)
> libbrotlicommon.so.1 => /lib64/libbrotlicommon.so.1 (0x00007fb994b65000)
> libopenblaso.so.0 => /lib64/libopenblaso.so.0 (0x00007fb992e1b000)
> liblapack.so.3 => /lib64/liblapack.so.3 (0x00007fb99257a000)
> libsz.so.2 => /lib64/libsz.so.2 (0x00007fb992377000)
> libarpack.so.2 => /lib64/libarpack.so.2 (0x00007fb992129000)
> libsuperlu.so.5.1 => /lib64/libsuperlu.so.5.1 (0x00007fb991eb3000)
> libfreetype.so.6 => /lib64/libfreetype.so.6 (0x00007fb991bf7000)
> libfontconfig.so.1 => /lib64/libfontconfig.so.1 (0x00007fb9919b2000)
> libsmime3.so => /lib64/libsmime3.so (0x00007fb991789000)
> libnss3.so => /lib64/libnss3.so (0x00007fb991453000)
> libnspr4.so => /lib64/libnspr4.so (0x00007fb991212000)
> liblcms2.so.2 => /lib64/liblcms2.so.2 (0x00007fb990fb5000)
> libltdl.so.7 => /lib64/libltdl.so.7 (0x00007fb990dab000)
> libhdf5_hl.so.100 => /lib64/libhdf5_hl.so.100 (0x00007fb990b87000)
> libbz2.so.1 => /lib64/libbz2.so.1 (0x00007fb990976000)
> libldap_r-2.4.so.2 => /lib64/libldap_r-2.4.so.2 (0x00007fb990720000)
> libuuid.so.1 => /lib64/libuuid.so.1 (0x00007fb990518000)
> libselinux.so.1 => /lib64/libselinux.so.1 (0x00007fb9902ed000)
> libcrypt.so.1 => /lib64/libcrypt.so.1 (0x00007fb9900c4000)
> libgfortran.so.5 => /lib64/libgfortran.so.5 (0x00007fb98fc47000)
> libgomp.so.1 => /lib64/libgomp.so.1 (0x00007fb98fa0f000)
> libblas.so.3 => /lib64/libblas.so.3 (0x00007fb98f7bb000)
> libaec.so.0 => /lib64/libaec.so.0 (0x00007fb98f5b3000)
> libopenblasp.so.0 => /lib64/libopenblasp.so.0 (0x00007fb98d868000)
> libquadmath.so.0 => /lib64/libquadmath.so.0 (0x00007fb98d627000)
> libsatlas.so.3 => /usr/lib64/atlas/libsatlas.so.3 (0x00007fb98c84c000)
> libnssutil3.so => /lib64/libnssutil3.so (0x00007fb98c61b000)
> libplc4.so => /lib64/libplc4.so (0x00007fb98c416000)
> libplds4.so => /lib64/libplds4.so (0x00007fb98c212000)
> libpcre2-8.so.0 => /lib64/libpcre2-8.so.0 (0x00007fb98bf8e000)
> 
>>ldd postgis-2.5.so  #probably need to specify full path
>>
> 
> I test with postgis 3.0
> 
> ldd /usr/pgsql-12/lib/postgis-3.so
> linux-vdso.so.1 (0x00007ffd9018c000)
> libm.so.6 => /lib64/libm.so.6 (0x00007f91f48a4000)
> libstdc++.so.6 => /lib64/libstdc++.so.6 (0x00007f91f450f000)
> libgeos_c.so.1 => /usr/geos38/lib64/libgeos_c.so.1 (0x00007f91f42d2000)
> libproj.so.19 => /usr/proj71/lib/libproj.so.19 (0x00007f91f3dbf000)
> libjson-c.so.4 => /lib64/libjson-c.so.4 (0x00007f91f3baf000)
> libprotobuf-c.so.1 => /lib64/libprotobuf-c.so.1 (0x00007f91f39a6000)
> libxml2.so.2 => /lib64/libxml2.so.2 (0x00007f91f363e000)
> libz.so.1 => /lib64/libz.so.1 (0x00007f91f3427000)
> liblzma.so.5 => /lib64/liblzma.so.5 (0x00007f91f3200000)
> libdl.so.2 => /lib64/libdl.so.2 (0x00007f91f2ffc000)
> libSFCGAL.so.1 => /lib64/libSFCGAL.so.1 (0x00007f91f2305000)
> libgcc_s.so.1 => /lib64/libgcc_s.so.1 (0x00007f91f20ed000)
> libc.so.6 => /lib64/libc.so.6 (0x00007f91f1d2b000)
> /lib64/ld-linux-x86-64.so.2 (0x00007f91f4f8d000)
> libgeos-3.8.1.so => /usr/geos38/lib64/libgeos-3.8.1.so (0x00007f91f1956000)
> libsqlite3.so.0 => /lib64/libsqlite3.so.0 (0x00007f91f1643000)
> libtiff.so.5 => /lib64/libtiff.so.5 (0x00007f91f13ca000)
> libcurl.so.4 => /lib64/libcurl.so.4 (0x00007f91f113c000)
> libpthread.so.0 => /lib64/libpthread.so.0 (0x00007f91f0f1c000)
> libCGAL_Core.so.13 => /usr/lib64/libCGAL_Core.so.13 (0x00007f91f0c7c000)
> libboost_thread.so.1.66.0 => /usr/lib64/libboost_thread.so.1.66.0
> (0x00007f91f0a50000)
> libboost_system.so.1.66.0 => /usr/lib64/libboost_system.so.1.66.0
> (0x00007f91f084b000)
> libboost_serialization.so.1.66.0 =>
> /usr/lib64/libboost_serialization.so.1.66.0 (0x00007f91f060a000)
> libboost_chrono.so.1.66.0 => /usr/lib64/libboost_chrono.so.1.66.0
> (0x00007f91f0401000)
> libboost_date_time.so.1.66.0 => /usr/lib64/libboost_date_time.so.1.66.0
> (0x00007f91f01ee000)
> libboost_atomic.so.1.66.0 => /usr/lib64/libboost_atomic.so.1.66.0
> (0x00007f91effec000)
> libCGAL.so.13 => /usr/lib64/libCGAL.so.13 (0x00007f91efdcd000)
> libmpfr.so.4 => /usr/lib64/libmpfr.so.4 (0x00007f91efb69000)
> libgmp.so.10 => /usr/lib64/libgmp.so.10 (0x00007f91ef8d1000)
> libjbig.so.2.1 => /lib64/libjbig.so.2.1 (0x00007f91ef6c5000)
> libjpeg.so.62 => /lib64/libjpeg.so.62 (0x00007f91ef45c000)
> libnghttp2.so.14 => /lib64/libnghttp2.so.14 (0x00007f91ef235000)
> libidn2.so.0 => /lib64/libidn2.so.0 (0x00007f91ef017000)
> libssh.so.4 => /lib64/libssh.so.4 (0x00007f91eed8c000)
> libpsl.so.5 => /lib64/libpsl.so.5 (0x00007f91eeb7b000)
> libssl.so.1.1 => /lib64/libssl.so.1.1 (0x00007f91ee8e7000)
> libcrypto.so.1.1 => /lib64/libcrypto.so.1.1 (0x00007f91ee404000)
> libgssapi_krb5.so.2 => /lib64/libgssapi_krb5.so.2 (0x00007f91ee1b4000)
> libkrb5.so.3 => /lib64/libkrb5.so.3 (0x00007f91edec4000)
> libk5crypto.so.3 => /lib64/libk5crypto.so.3 (0x00007f91edca8000)
> libcom_err.so.2 => /lib64/libcom_err.so.2 (0x00007f91edaa4000)
> libldap-2.4.so.2 => /lib64/libldap-2.4.so.2 (0x00007f91ed857000)
> liblber-2.4.so.2 => /lib64/liblber-2.4.so.2 (0x00007f91ed647000)
> libbrotlidec.so.1 => /lib64/libbrotlidec.so.1 (0x00007f91ed43b000)
> librt.so.1 => /usr/lib64/librt.so.1 (0x00007f91ed232000)
> libunistring.so.2 => /lib64/libunistring.so.2 (0x00007f91eceb1000)
> libkrb5support.so.0 => /lib64/libkrb5support.so.0 (0x00007f91ecca0000)
> libkeyutils.so.1 => /lib64/libkeyutils.so.1 (0x00007f91eca9c000)
> libresolv.so.2 => /lib64/libresolv.so.2 (0x00007f91ec885000)
> libsasl2.so.3 => /lib64/libsasl2.so.3 (0x00007f91ec667000)
> libbrotlicommon.so.1 => /lib64/libbrotlicommon.so.1 (0x00007f91ec447000)
> libselinux.so.1 => /lib64/libselinux.so.1 (0x00007f91ec21c000)
> libcrypt.so.1 => /lib64/libcrypt.so.1 (0x00007f91ebff3000)
> libpcre2-8.so.0 => /lib64/libpcre2-8.so.0 (0x00007f91ebd6f000)
> 
>>
>>
>>
>>
>>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.
>>
> 
> rpm  -qa|grep gdal
> gdal31-libs-debuginfo-3.1.3-2.rhel8.x86_64
> gdal31-libs-3.1.3-2.rhel8.x86_64
> gdal31-debuginfo-3.1.3-2.rhel8.x86_64
> gdal31-debugsource-3.1.3-2.rhel8.x86_64
> gdal31-devel-3.1.3-2.rhel8.x86_64
> gdal31-doc-3.1.3-2.rhel8.noarch
> 
> rpm  -qa|grep proj
> proj71-debuginfo-7.1.1-1.rhel8.x86_64
> proj-6.3.2-4.el8.x86_64
> proj71-debugsource-7.1.1-1.rhel8.x86_64
> proj71-7.1.1-1.rhel8.x86_64
> proj-datumgrid-1.8-6.3.2.4.el8.noarch
> proj71-devel-7.1.1-1.rhel8.x86_64
> proj71-static-7.1.1-1.rhel8.x86_64
> 
> Thanks.
> 
> Lars
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-users
> 

J. Gustavo
-- 
Jorge Gustavo Rocha
Departamento de Informática
Universidade do Minho
4710-057 Braga
Gabinete 3.29 (Piso 3)
Tel: +351 253604480
Fax: +351 253604471
Móvel: +351 910333888
skype: nabocudnosor