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

Thu Nov 5 03:09:11 PST 2020

>From: postgis-users <postgis-users-bounces at lists.osgeo.org> on behalf of Regina Obe <lr at pcorp.us>Sent: Thursday, November 5, 2020 11:52 AMTo: 'PostGIS Users Discussion' <postgis-users at lists.osgeo.org>Subject: Re: [postgis-users] Problem raster2pgsql on Centos 8 - postgres 12 / postgis 2.5
>
>
>
>From your postgis output you are running unreleased version of PostGIS.  Is that intentional?  Did you compile yourself?  I didn’t think any distribution had this particular version as it has 3.1.0dev in it.  I know distributions have 3.1.0alpha2
>
>
>
>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
>

Hi

Yes this one I compiled to test some more, but I got same problem when installing with yum.
Magnus Hagender also tested with yum and he also indicate problems with proj (https://redmine.postgresql.org/issues/5961) .

>
>
>
>Can you also output what
>
>
>
>ldd /usr/pgsql-12/lib/postgis_raster-3.so
>
>
>
>returns  could be for some reason your raster piece is perhaps compild with proj 6.3.2 and your regular PostGIS is proj 7.1.1
>
ldd /usr/pgsql-12/lib/postgis_raster-3.so
linux-vdso.so.1 (0x00007ffc6efc8000)
libgdal.so.27 => /usr/gdal31/lib/libgdal.so.27 (0x00007fa177365000)
libgeos_c.so.1 => /usr/geos38/lib64/libgeos_c.so.1 (0x00007fa177128000)
libproj.so.19 => /usr/proj71/lib/libproj.so.19 (0x00007fa176c15000)
libm.so.6 => /lib64/libm.so.6 (0x00007fa176893000)
libc.so.6 => /lib64/libc.so.6 (0x00007fa1764d1000)
libarmadillo.so.9 => /lib64/libarmadillo.so.9 (0x00007fa1762c0000)
libpoppler.so.78 => /lib64/libpoppler.so.78 (0x00007fa175dda000)
libjson-c.so.4 => /lib64/libjson-c.so.4 (0x00007fa175bca000)
libfreexl.so.1 => /lib64/libfreexl.so.1 (0x00007fa1759c0000)
libSFCGAL.so.1 => /lib64/libSFCGAL.so.1 (0x00007fa174cc9000)
libwebp.so.7 => /lib64/libwebp.so.7 (0x00007fa174a5b000)
libodbc.so.2 => /lib64/libodbc.so.2 (0x00007fa1747ea000)
libodbcinst.so.2 => /lib64/libodbcinst.so.2 (0x00007fa1745d4000)
libexpat.so.1 => /lib64/libexpat.so.1 (0x00007fa174399000)
libxerces-c-3.2.so => /lib64/libxerces-c-3.2.so (0x00007fa173dc6000)
libopenjp2.so.7 => /lib64/libopenjp2.so.7 (0x00007fa173b74000)
libjasper.so.4 => /lib64/libjasper.so.4 (0x00007fa173916000)
libnetcdf.so.15 => /lib64/libnetcdf.so.15 (0x00007fa1735ca000)
libhdf5.so.103 => /lib64/libhdf5.so.103 (0x00007fa17303f000)
libmfhdf.so.0 => /lib64/libmfhdf.so.0 (0x00007fa172e16000)
libdf.so.0 => /lib64/libdf.so.0 (0x00007fa172b6d000)
libogdi.so.4 => /lib64/libogdi.so.4 (0x00007fa172950000)
libgif.so.7 => /lib64/libgif.so.7 (0x00007fa172746000)
libjpeg.so.62 => /lib64/libjpeg.so.62 (0x00007fa1724dd000)
libgeotiff.so.5 => /usr/libgeotiff16/lib/libgeotiff.so.5 (0x00007fa1722aa000)
libtiff.so.5 => /lib64/libtiff.so.5 (0x00007fa172031000)
libgta.so.1 => /lib64/libgta.so.1 (0x00007fa171e27000)
libpng16.so.16 => /lib64/libpng16.so.16 (0x00007fa171bf2000)
libcfitsio.so.7 => /lib64/libcfitsio.so.7 (0x00007fa1716e7000)
libpq.so.5 => /lib64/libpq.so.5 (0x00007fa171496000)
libzstd.so.1 => /lib64/libzstd.so.1 (0x00007fa1711f4000)
liblzma.so.5 => /lib64/liblzma.so.5 (0x00007fa170fcd000)
libproj.so.15 => not found
libsqlite3.so.0 => /lib64/libsqlite3.so.0 (0x00007fa170cba000)
librt.so.1 => /lib64/librt.so.1 (0x00007fa170ab1000)
libtirpc.so.3 => /lib64/libtirpc.so.3 (0x00007fa17087e000)
libdapclient.so.6 => /lib64/libdapclient.so.6 (0x00007fa170634000)
libdapserver.so.7 => /lib64/libdapserver.so.7 (0x00007fa170423000)
libdap.so.25 => /lib64/libdap.so.25 (0x00007fa170067000)
libspatialite.so.7 => /lib64/libspatialite.so.7 (0x00007fa16f82c000)
libpcre.so.1 => /lib64/libpcre.so.1 (0x00007fa16f5bb000)
libcurl.so.4 => /lib64/libcurl.so.4 (0x00007fa16f32d000)
libxml2.so.2 => /lib64/libxml2.so.2 (0x00007fa16efc5000)
libmariadb.so.3 => /lib64/libmariadb.so.3 (0x00007fa16ed73000)
libz.so.1 => /lib64/libz.so.1 (0x00007fa16eb5c000)
libdl.so.2 => /lib64/libdl.so.2 (0x00007fa16e958000)
libpthread.so.0 => /lib64/libpthread.so.0 (0x00007fa16e738000)
libssl.so.1.1 => /lib64/libssl.so.1.1 (0x00007fa16e4a4000)
libcrypto.so.1.1 => /lib64/libcrypto.so.1.1 (0x00007fa16dfc1000)
libstdc++.so.6 => /lib64/libstdc++.so.6 (0x00007fa16dc2c000)
/lib64/ld-linux-x86-64.so.2 (0x00007fa179014000)
libgcc_s.so.1 => /lib64/libgcc_s.so.1 (0x00007fa16da14000)
libgeos-3.8.1.so => /usr/geos38/lib64/libgeos-3.8.1.so (0x00007fa16d63f000)
libopenblaso.so.0 => /lib64/libopenblaso.so.0 (0x00007fa16b8f5000)
liblapack.so.3 => /lib64/liblapack.so.3 (0x00007fa16b054000)
libsz.so.2 => /lib64/libsz.so.2 (0x00007fa16ae51000)
libarpack.so.2 => /lib64/libarpack.so.2 (0x00007fa16ac03000)
libsuperlu.so.5.1 => /lib64/libsuperlu.so.5.1 (0x00007fa16a98d000)
libfreetype.so.6 => /lib64/libfreetype.so.6 (0x00007fa16a6d1000)
libfontconfig.so.1 => /lib64/libfontconfig.so.1 (0x00007fa16a48c000)
libsmime3.so => /lib64/libsmime3.so (0x00007fa16a263000)
libnss3.so => /lib64/libnss3.so (0x00007fa169f2d000)
libnspr4.so => /lib64/libnspr4.so (0x00007fa169cec000)
liblcms2.so.2 => /lib64/liblcms2.so.2 (0x00007fa169a8f000)
libCGAL_Core.so.13 => /usr/lib64/libCGAL_Core.so.13 (0x00007fa1697ef000)
libboost_thread.so.1.66.0 => /usr/lib64/libboost_thread.so.1.66.0 (0x00007fa1695c3000)
libboost_system.so.1.66.0 => /usr/lib64/libboost_system.so.1.66.0 (0x00007fa1693be000)
libboost_serialization.so.1.66.0 => /usr/lib64/libboost_serialization.so.1.66.0 (0x00007fa16917d000)
libboost_chrono.so.1.66.0 => /usr/lib64/libboost_chrono.so.1.66.0 (0x00007fa168f74000)
libboost_date_time.so.1.66.0 => /usr/lib64/libboost_date_time.so.1.66.0 (0x00007fa168d61000)
libboost_atomic.so.1.66.0 => /usr/lib64/libboost_atomic.so.1.66.0 (0x00007fa168b5f000)
libCGAL.so.13 => /usr/lib64/libCGAL.so.13 (0x00007fa168940000)
libmpfr.so.4 => /usr/lib64/libmpfr.so.4 (0x00007fa1686dc000)
libgmp.so.10 => /usr/lib64/libgmp.so.10 (0x00007fa168444000)
libltdl.so.7 => /lib64/libltdl.so.7 (0x00007fa16823a000)
libhdf5_hl.so.100 => /lib64/libhdf5_hl.so.100 (0x00007fa168016000)
libjbig.so.2.1 => /lib64/libjbig.so.2.1 (0x00007fa167e0a000)
libbz2.so.1 => /lib64/libbz2.so.1 (0x00007fa167bf9000)
libgssapi_krb5.so.2 => /lib64/libgssapi_krb5.so.2 (0x00007fa1679a9000)
libldap_r-2.4.so.2 => /lib64/libldap_r-2.4.so.2 (0x00007fa167753000)
libkrb5.so.3 => /lib64/libkrb5.so.3 (0x00007fa167463000)
libk5crypto.so.3 => /lib64/libk5crypto.so.3 (0x00007fa167247000)
libcom_err.so.2 => /lib64/libcom_err.so.2 (0x00007fa167043000)
libuuid.so.1 => /lib64/libuuid.so.1 (0x00007fa166e3b000)
libproj.so.15 => not found
libnghttp2.so.14 => /lib64/libnghttp2.so.14 (0x00007fa166c14000)
libidn2.so.0 => /lib64/libidn2.so.0 (0x00007fa1669f6000)
libssh.so.4 => /lib64/libssh.so.4 (0x00007fa16676b000)
libpsl.so.5 => /lib64/libpsl.so.5 (0x00007fa16655a000)
libldap-2.4.so.2 => /lib64/libldap-2.4.so.2 (0x00007fa16630d000)
liblber-2.4.so.2 => /lib64/liblber-2.4.so.2 (0x00007fa1660fd000)
libbrotlidec.so.1 => /lib64/libbrotlidec.so.1 (0x00007fa165ef1000)
libgfortran.so.5 => /lib64/libgfortran.so.5 (0x00007fa165a74000)
libgomp.so.1 => /lib64/libgomp.so.1 (0x00007fa16583c000)
libblas.so.3 => /lib64/libblas.so.3 (0x00007fa1655e8000)
libaec.so.0 => /lib64/libaec.so.0 (0x00007fa1653e0000)
libopenblasp.so.0 => /lib64/libopenblasp.so.0 (0x00007fa163695000)
libquadmath.so.0 => /lib64/libquadmath.so.0 (0x00007fa163454000)
libsatlas.so.3 => /usr/lib64/atlas/libsatlas.so.3 (0x00007fa162679000)
libnssutil3.so => /lib64/libnssutil3.so (0x00007fa162448000)
libplc4.so => /lib64/libplc4.so (0x00007fa162243000)
libplds4.so => /lib64/libplds4.so (0x00007fa16203f000)
libkrb5support.so.0 => /lib64/libkrb5support.so.0 (0x00007fa161e2e000)
libkeyutils.so.1 => /lib64/libkeyutils.so.1 (0x00007fa161c2a000)
libresolv.so.2 => /lib64/libresolv.so.2 (0x00007fa161a13000)
libsasl2.so.3 => /lib64/libsasl2.so.3 (0x00007fa1617f5000)
libunistring.so.2 => /lib64/libunistring.so.2 (0x00007fa161474000)
libbrotlicommon.so.1 => /lib64/libbrotlicommon.so.1 (0x00007fa161254000)
libselinux.so.1 => /lib64/libselinux.so.1 (0x00007fa161029000)
libcrypt.so.1 => /lib64/libcrypt.so.1 (0x00007fa160e00000)
libpcre2-8.so.0 => /lib64/libpcre2-8.so.0 (0x00007fa160b7c000)
Thanks.

Lars
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20201105/eb82d375/attachment.html>