<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=Windows-1252">
<style type="text/css" style="display:none;"> P {margin-top:0;margin-bottom:0;} </style>
</head>
<body dir="ltr">
>
<div>></div>
<div>>From: postgis-users <postgis-users-bounces@lists.osgeo.org> on behalf of Regina Obe <lr@pcorp.us>Sent: Wednesday, November 4, 2020 11:05 PMTo: 'PostGIS Users Discussion' <postgis-users@lists.osgeo.org>Subject: Re: [postgis-users] Problem raster2pgsql
on Centos 8 - postgres 12 / postgis 2.5</div>
<div>> </div>
<div>></div>
<div>>Sounds from the below thread the issue is with proj and the interaction with GDAL.</div>
<div>></div>
<div>> </div>
<div>></div>
<div>>Can both of you let me know what the output of</div>
<div>></div>
<div>> </div>
<div>></div>
<div>>SELECT postgis_full_version()l</div>
<div>></div>
<div><br>
</div>
<div>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"</div>
<div> LIBPROTOBUF="1.3.0" WAGYU="0.5.0 (Internal)" TOPOLOGY RASTER</div>
<div>> </div>
<div>></div>
<div>>Gives – and also do an</div>
<div>></div>
<div>> </div>
<div>></div>
<div>>ldd raster2pgsql</div>
<div>></div>
<div><br>
</div>
<div>ldd /usr/pgsql-12/bin/raster2pgsql</div>
<div>linux-vdso.so.1 (0x00007fffee50b000)</div>
<div>libm.so.6 => /lib64/libm.so.6 (0x00007fb9a42f0000)</div>
<div>libproj.so.19 => /usr/proj71/lib/libproj.so.19 (0x00007fb9a3ddd000)</div>
<div>libsqlite3.so.0 => /lib64/libsqlite3.so.0 (0x00007fb9a3aca000)</div>
<div>libtiff.so.5 => /lib64/libtiff.so.5 (0x00007fb9a3851000)</div>
<div>libcurl.so.4 => /lib64/libcurl.so.4 (0x00007fb9a35c3000)</div>
<div>libpthread.so.0 => /lib64/libpthread.so.0 (0x00007fb9a33a3000)</div>
<div>libdl.so.2 => /lib64/libdl.so.2 (0x00007fb9a319f000)</div>
<div>libjson-c.so.4 => /lib64/libjson-c.so.4 (0x00007fb9a2f8f000)</div>
<div>libSFCGAL.so.1 => /lib64/libSFCGAL.so.1 (0x00007fb9a2298000)</div>
<div>libgdal.so.27 => /usr/gdal31/lib/libgdal.so.27 (0x00007fb9a08ad000)</div>
<div>libgeos_c.so.1 => /usr/geos38/lib64/libgeos_c.so.1 (0x00007fb9a0670000)</div>
<div>libc.so.6 => /lib64/libc.so.6 (0x00007fb9a02ae000)</div>
<div>/lib64/ld-linux-x86-64.so.2 (0x00007fb9a4672000)</div>
<div>libstdc++.so.6 => /lib64/libstdc++.so.6 (0x00007fb99ff19000)</div>
<div>libgcc_s.so.1 => /lib64/libgcc_s.so.1 (0x00007fb99fd01000)</div>
<div>libz.so.1 => /lib64/libz.so.1 (0x00007fb99faea000)</div>
<div>libjbig.so.2.1 => /lib64/libjbig.so.2.1 (0x00007fb99f8de000)</div>
<div>libjpeg.so.62 => /lib64/libjpeg.so.62 (0x00007fb99f675000)</div>
<div>libnghttp2.so.14 => /lib64/libnghttp2.so.14 (0x00007fb99f44e000)</div>
<div>libidn2.so.0 => /lib64/libidn2.so.0 (0x00007fb99f230000)</div>
<div>libssh.so.4 => /lib64/libssh.so.4 (0x00007fb99efa5000)</div>
<div>libpsl.so.5 => /lib64/libpsl.so.5 (0x00007fb99ed94000)</div>
<div>libssl.so.1.1 => /lib64/libssl.so.1.1 (0x00007fb99eb00000)</div>
<div>libcrypto.so.1.1 => /lib64/libcrypto.so.1.1 (0x00007fb99e61d000)</div>
<div>libgssapi_krb5.so.2 => /lib64/libgssapi_krb5.so.2 (0x00007fb99e3cd000)</div>
<div>libkrb5.so.3 => /lib64/libkrb5.so.3 (0x00007fb99e0dd000)</div>
<div>libk5crypto.so.3 => /lib64/libk5crypto.so.3 (0x00007fb99dec1000)</div>
<div>libcom_err.so.2 => /lib64/libcom_err.so.2 (0x00007fb99dcbd000)</div>
<div>libldap-2.4.so.2 => /lib64/libldap-2.4.so.2 (0x00007fb99da70000)</div>
<div>liblber-2.4.so.2 => /lib64/liblber-2.4.so.2 (0x00007fb99d860000)</div>
<div>libbrotlidec.so.1 => /lib64/libbrotlidec.so.1 (0x00007fb99d654000)</div>
<div>libCGAL_Core.so.13 => /usr/lib64/libCGAL_Core.so.13 (0x00007fb99d3b4000)</div>
<div>libboost_thread.so.1.66.0 => /usr/lib64/libboost_thread.so.1.66.0 (0x00007fb99d188000)</div>
<div>libboost_system.so.1.66.0 => /usr/lib64/libboost_system.so.1.66.0 (0x00007fb99cf83000)</div>
<div>libboost_serialization.so.1.66.0 => /usr/lib64/libboost_serialization.so.1.66.0 (0x00007fb99cd42000)</div>
<div>libboost_chrono.so.1.66.0 => /usr/lib64/libboost_chrono.so.1.66.0 (0x00007fb99cb39000)</div>
<div>libboost_date_time.so.1.66.0 => /usr/lib64/libboost_date_time.so.1.66.0 (0x00007fb99c926000)</div>
<div>libboost_atomic.so.1.66.0 => /usr/lib64/libboost_atomic.so.1.66.0 (0x00007fb99c724000)</div>
<div>libCGAL.so.13 => /usr/lib64/libCGAL.so.13 (0x00007fb99c505000)</div>
<div>libmpfr.so.4 => /usr/lib64/libmpfr.so.4 (0x00007fb99c2a1000)</div>
<div>libgmp.so.10 => /usr/lib64/libgmp.so.10 (0x00007fb99c009000)</div>
<div>libarmadillo.so.9 => /lib64/libarmadillo.so.9 (0x00007fb99bdf8000)</div>
<div>libpoppler.so.78 => /lib64/libpoppler.so.78 (0x00007fb99b912000)</div>
<div>libfreexl.so.1 => /lib64/libfreexl.so.1 (0x00007fb99b708000)</div>
<div>libwebp.so.7 => /lib64/libwebp.so.7 (0x00007fb99b49a000)</div>
<div>libodbc.so.2 => /lib64/libodbc.so.2 (0x00007fb99b229000)</div>
<div>libodbcinst.so.2 => /lib64/libodbcinst.so.2 (0x00007fb99b013000)</div>
<div>libexpat.so.1 => /lib64/libexpat.so.1 (0x00007fb99add8000)</div>
<div>libxerces-c-3.2.so => /lib64/libxerces-c-3.2.so (0x00007fb99a805000)</div>
<div>libopenjp2.so.7 => /lib64/libopenjp2.so.7 (0x00007fb99a5b3000)</div>
<div>libjasper.so.4 => /lib64/libjasper.so.4 (0x00007fb99a355000)</div>
<div>libnetcdf.so.15 => /lib64/libnetcdf.so.15 (0x00007fb99a009000)</div>
<div>libhdf5.so.103 => /lib64/libhdf5.so.103 (0x00007fb999a7e000)</div>
<div>libmfhdf.so.0 => /lib64/libmfhdf.so.0 (0x00007fb999855000)</div>
<div>libdf.so.0 => /lib64/libdf.so.0 (0x00007fb9995ac000)</div>
<div>libogdi.so.4 => /lib64/libogdi.so.4 (0x00007fb99938f000)</div>
<div>libgif.so.7 => /lib64/libgif.so.7 (0x00007fb999185000)</div>
<div>libgeotiff.so.5 => /usr/libgeotiff16/lib/libgeotiff.so.5 (0x00007fb998f52000)</div>
<div>libgta.so.1 => /lib64/libgta.so.1 (0x00007fb998d48000)</div>
<div>libpng16.so.16 => /lib64/libpng16.so.16 (0x00007fb998b13000)</div>
<div>libcfitsio.so.7 => /lib64/libcfitsio.so.7 (0x00007fb998608000)</div>
<div>libpq.so.5 => /lib64/libpq.so.5 (0x00007fb9983b7000)</div>
<div>libzstd.so.1 => /lib64/libzstd.so.1 (0x00007fb998115000)</div>
<div>liblzma.so.5 => /lib64/liblzma.so.5 (0x00007fb997eee000)</div>
<div>libproj.so.15 => /lib64/libproj.so.15 (0x00007fb9979de000)</div>
<div>librt.so.1 => /lib64/librt.so.1 (0x00007fb9977d5000)</div>
<div>libtirpc.so.3 => /lib64/libtirpc.so.3 (0x00007fb9975a2000)</div>
<div>libdapclient.so.6 => /lib64/libdapclient.so.6 (0x00007fb997358000)</div>
<div>libdapserver.so.7 => /lib64/libdapserver.so.7 (0x00007fb997147000)</div>
<div>libdap.so.25 => /lib64/libdap.so.25 (0x00007fb996d8b000)</div>
<div>libspatialite.so.7 => /lib64/libspatialite.so.7 (0x00007fb996550000)</div>
<div>libpcre.so.1 => /lib64/libpcre.so.1 (0x00007fb9962df000)</div>
<div>libxml2.so.2 => /lib64/libxml2.so.2 (0x00007fb995f77000)</div>
<div>libmariadb.so.3 => /lib64/libmariadb.so.3 (0x00007fb995d25000)</div>
<div>libgeos-3.8.1.so => /usr/geos38/lib64/libgeos-3.8.1.so (0x00007fb995950000)</div>
<div>libunistring.so.2 => /lib64/libunistring.so.2 (0x00007fb9955cf000)</div>
<div>libkrb5support.so.0 => /lib64/libkrb5support.so.0 (0x00007fb9953be000)</div>
<div>libkeyutils.so.1 => /lib64/libkeyutils.so.1 (0x00007fb9951ba000)</div>
<div>libresolv.so.2 => /lib64/libresolv.so.2 (0x00007fb994fa3000)</div>
<div>libsasl2.so.3 => /lib64/libsasl2.so.3 (0x00007fb994d85000)</div>
<div>libbrotlicommon.so.1 => /lib64/libbrotlicommon.so.1 (0x00007fb994b65000)</div>
<div>libopenblaso.so.0 => /lib64/libopenblaso.so.0 (0x00007fb992e1b000)</div>
<div>liblapack.so.3 => /lib64/liblapack.so.3 (0x00007fb99257a000)</div>
<div>libsz.so.2 => /lib64/libsz.so.2 (0x00007fb992377000)</div>
<div>libarpack.so.2 => /lib64/libarpack.so.2 (0x00007fb992129000)</div>
<div>libsuperlu.so.5.1 => /lib64/libsuperlu.so.5.1 (0x00007fb991eb3000)</div>
<div>libfreetype.so.6 => /lib64/libfreetype.so.6 (0x00007fb991bf7000)</div>
<div>libfontconfig.so.1 => /lib64/libfontconfig.so.1 (0x00007fb9919b2000)</div>
<div>libsmime3.so => /lib64/libsmime3.so (0x00007fb991789000)</div>
<div>libnss3.so => /lib64/libnss3.so (0x00007fb991453000)</div>
<div>libnspr4.so => /lib64/libnspr4.so (0x00007fb991212000)</div>
<div>liblcms2.so.2 => /lib64/liblcms2.so.2 (0x00007fb990fb5000)</div>
<div>libltdl.so.7 => /lib64/libltdl.so.7 (0x00007fb990dab000)</div>
<div>libhdf5_hl.so.100 => /lib64/libhdf5_hl.so.100 (0x00007fb990b87000)</div>
<div>libbz2.so.1 => /lib64/libbz2.so.1 (0x00007fb990976000)</div>
<div>libldap_r-2.4.so.2 => /lib64/libldap_r-2.4.so.2 (0x00007fb990720000)</div>
<div>libuuid.so.1 => /lib64/libuuid.so.1 (0x00007fb990518000)</div>
<div>libselinux.so.1 => /lib64/libselinux.so.1 (0x00007fb9902ed000)</div>
<div>libcrypt.so.1 => /lib64/libcrypt.so.1 (0x00007fb9900c4000)</div>
<div>libgfortran.so.5 => /lib64/libgfortran.so.5 (0x00007fb98fc47000)</div>
<div>libgomp.so.1 => /lib64/libgomp.so.1 (0x00007fb98fa0f000)</div>
<div>libblas.so.3 => /lib64/libblas.so.3 (0x00007fb98f7bb000)</div>
<div>libaec.so.0 => /lib64/libaec.so.0 (0x00007fb98f5b3000)</div>
<div>libopenblasp.so.0 => /lib64/libopenblasp.so.0 (0x00007fb98d868000)</div>
<div>libquadmath.so.0 => /lib64/libquadmath.so.0 (0x00007fb98d627000)</div>
<div>libsatlas.so.3 => /usr/lib64/atlas/libsatlas.so.3 (0x00007fb98c84c000)</div>
<div>libnssutil3.so => /lib64/libnssutil3.so (0x00007fb98c61b000)</div>
<div>libplc4.so => /lib64/libplc4.so (0x00007fb98c416000)</div>
<div>libplds4.so => /lib64/libplds4.so (0x00007fb98c212000)</div>
<div>libpcre2-8.so.0 => /lib64/libpcre2-8.so.0 (0x00007fb98bf8e000)</div>
<div><br>
</div>
<div>>ldd postgis-2.5.so #probably need to specify full path</div>
<div>></div>
<div><br>
</div>
<div>I test with postgis 3.0</div>
<div><br>
</div>
<div>ldd /usr/pgsql-12/lib/postgis-3.so</div>
<div>linux-vdso.so.1 (0x00007ffd9018c000)</div>
<div>libm.so.6 => /lib64/libm.so.6 (0x00007f91f48a4000)</div>
<div>libstdc++.so.6 => /lib64/libstdc++.so.6 (0x00007f91f450f000)</div>
<div>libgeos_c.so.1 => /usr/geos38/lib64/libgeos_c.so.1 (0x00007f91f42d2000)</div>
<div>libproj.so.19 => /usr/proj71/lib/libproj.so.19 (0x00007f91f3dbf000)</div>
<div>libjson-c.so.4 => /lib64/libjson-c.so.4 (0x00007f91f3baf000)</div>
<div>libprotobuf-c.so.1 => /lib64/libprotobuf-c.so.1 (0x00007f91f39a6000)</div>
<div>libxml2.so.2 => /lib64/libxml2.so.2 (0x00007f91f363e000)</div>
<div>libz.so.1 => /lib64/libz.so.1 (0x00007f91f3427000)</div>
<div>liblzma.so.5 => /lib64/liblzma.so.5 (0x00007f91f3200000)</div>
<div>libdl.so.2 => /lib64/libdl.so.2 (0x00007f91f2ffc000)</div>
<div>libSFCGAL.so.1 => /lib64/libSFCGAL.so.1 (0x00007f91f2305000)</div>
<div>libgcc_s.so.1 => /lib64/libgcc_s.so.1 (0x00007f91f20ed000)</div>
<div>libc.so.6 => /lib64/libc.so.6 (0x00007f91f1d2b000)</div>
<div>/lib64/ld-linux-x86-64.so.2 (0x00007f91f4f8d000)</div>
<div>libgeos-3.8.1.so => /usr/geos38/lib64/libgeos-3.8.1.so (0x00007f91f1956000)</div>
<div>libsqlite3.so.0 => /lib64/libsqlite3.so.0 (0x00007f91f1643000)</div>
<div>libtiff.so.5 => /lib64/libtiff.so.5 (0x00007f91f13ca000)</div>
<div>libcurl.so.4 => /lib64/libcurl.so.4 (0x00007f91f113c000)</div>
<div>libpthread.so.0 => /lib64/libpthread.so.0 (0x00007f91f0f1c000)</div>
<div>libCGAL_Core.so.13 => /usr/lib64/libCGAL_Core.so.13 (0x00007f91f0c7c000)</div>
<div>libboost_thread.so.1.66.0 => /usr/lib64/libboost_thread.so.1.66.0 (0x00007f91f0a50000)</div>
<div>libboost_system.so.1.66.0 => /usr/lib64/libboost_system.so.1.66.0 (0x00007f91f084b000)</div>
<div>libboost_serialization.so.1.66.0 => /usr/lib64/libboost_serialization.so.1.66.0 (0x00007f91f060a000)</div>
<div>libboost_chrono.so.1.66.0 => /usr/lib64/libboost_chrono.so.1.66.0 (0x00007f91f0401000)</div>
<div>libboost_date_time.so.1.66.0 => /usr/lib64/libboost_date_time.so.1.66.0 (0x00007f91f01ee000)</div>
<div>libboost_atomic.so.1.66.0 => /usr/lib64/libboost_atomic.so.1.66.0 (0x00007f91effec000)</div>
<div>libCGAL.so.13 => /usr/lib64/libCGAL.so.13 (0x00007f91efdcd000)</div>
<div>libmpfr.so.4 => /usr/lib64/libmpfr.so.4 (0x00007f91efb69000)</div>
<div>libgmp.so.10 => /usr/lib64/libgmp.so.10 (0x00007f91ef8d1000)</div>
<div>libjbig.so.2.1 => /lib64/libjbig.so.2.1 (0x00007f91ef6c5000)</div>
<div>libjpeg.so.62 => /lib64/libjpeg.so.62 (0x00007f91ef45c000)</div>
<div>libnghttp2.so.14 => /lib64/libnghttp2.so.14 (0x00007f91ef235000)</div>
<div>libidn2.so.0 => /lib64/libidn2.so.0 (0x00007f91ef017000)</div>
<div>libssh.so.4 => /lib64/libssh.so.4 (0x00007f91eed8c000)</div>
<div>libpsl.so.5 => /lib64/libpsl.so.5 (0x00007f91eeb7b000)</div>
<div>libssl.so.1.1 => /lib64/libssl.so.1.1 (0x00007f91ee8e7000)</div>
<div>libcrypto.so.1.1 => /lib64/libcrypto.so.1.1 (0x00007f91ee404000)</div>
<div>libgssapi_krb5.so.2 => /lib64/libgssapi_krb5.so.2 (0x00007f91ee1b4000)</div>
<div>libkrb5.so.3 => /lib64/libkrb5.so.3 (0x00007f91edec4000)</div>
<div>libk5crypto.so.3 => /lib64/libk5crypto.so.3 (0x00007f91edca8000)</div>
<div>libcom_err.so.2 => /lib64/libcom_err.so.2 (0x00007f91edaa4000)</div>
<div>libldap-2.4.so.2 => /lib64/libldap-2.4.so.2 (0x00007f91ed857000)</div>
<div>liblber-2.4.so.2 => /lib64/liblber-2.4.so.2 (0x00007f91ed647000)</div>
<div>libbrotlidec.so.1 => /lib64/libbrotlidec.so.1 (0x00007f91ed43b000)</div>
<div>librt.so.1 => /usr/lib64/librt.so.1 (0x00007f91ed232000)</div>
<div>libunistring.so.2 => /lib64/libunistring.so.2 (0x00007f91eceb1000)</div>
<div>libkrb5support.so.0 => /lib64/libkrb5support.so.0 (0x00007f91ecca0000)</div>
<div>libkeyutils.so.1 => /lib64/libkeyutils.so.1 (0x00007f91eca9c000)</div>
<div>libresolv.so.2 => /lib64/libresolv.so.2 (0x00007f91ec885000)</div>
<div>libsasl2.so.3 => /lib64/libsasl2.so.3 (0x00007f91ec667000)</div>
<div>libbrotlicommon.so.1 => /lib64/libbrotlicommon.so.1 (0x00007f91ec447000)</div>
<div>libselinux.so.1 => /lib64/libselinux.so.1 (0x00007f91ec21c000)</div>
<div>libcrypt.so.1 => /lib64/libcrypt.so.1 (0x00007f91ebff3000)</div>
<div>libpcre2-8.so.0 => /lib64/libpcre2-8.so.0 (0x00007f91ebd6f000)</div>
<div><br>
</div>
<div>> </div>
<div>></div>
<div>> </div>
<div>></div>
<div>>There have been many changes in proj and while we patched it in for general postgis vector use in 3.0, 3.1+ </div>
<div>></div>
<div>> </div>
<div>></div>
<div>>Depending on you mix of GDAL version and Proj. Those 2 might be incompatible.</div>
<div>></div>
<div>> </div>
<div>></div>
<div>>GDAL < 3 should ideally be using a Proj < 6</div>
<div>></div>
<div>> </div>
<div>></div>
<div>>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.</div>
<div>></div>
<div><br>
</div>
<div>rpm -qa|grep gdal</div>
<div>gdal31-libs-debuginfo-3.1.3-2.rhel8.x86_64</div>
<div>gdal31-libs-3.1.3-2.rhel8.x86_64</div>
<div>gdal31-debuginfo-3.1.3-2.rhel8.x86_64</div>
<div>gdal31-debugsource-3.1.3-2.rhel8.x86_64</div>
<div>gdal31-devel-3.1.3-2.rhel8.x86_64</div>
<div>gdal31-doc-3.1.3-2.rhel8.noarch</div>
<div><br>
</div>
<div>rpm -qa|grep proj</div>
<div>proj71-debuginfo-7.1.1-1.rhel8.x86_64</div>
<div>proj-6.3.2-4.el8.x86_64</div>
<div>proj71-debugsource-7.1.1-1.rhel8.x86_64</div>
<div>proj71-7.1.1-1.rhel8.x86_64</div>
<div>proj-datumgrid-1.8-6.3.2.4.el8.noarch</div>
<div>proj71-devel-7.1.1-1.rhel8.x86_64</div>
<div>proj71-static-7.1.1-1.rhel8.x86_64</div>
<div><br>
</div>
<div>Thanks.</div>
<div><br>
</div>
Lars
</body>
</html>