<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="Generator" content="Microsoft Exchange Server">
<!-- converted from rtf -->
<style><!-- .EmailQuote { margin-left: 1pt; padding-left: 4pt; border-left: #800000 2px solid; } --></style>
</head>
<body>
<font face="Calibri" size="2"><span style="font-size:11pt;">
<div>From: "Regina Obe" <<a href="mailto:lr@pcorp.us">lr@pcorp.us</a>></div>
<div> </div>
<div style="padding-left:35.4pt;">Sounds from the below thread the issue is with proj and the interaction with GDAL.</div>
<div style="padding-left:35.4pt;">Can both of you let me know what the output of</div>
<div style="padding-left:35.4pt;"> </div>
<div style="padding-left:35.4pt;">SELECT postgis_full_version()</div>
<div style="padding-left:35.4pt;"> </div>
<div style="padding-left:35.4pt;">Gives - and also do an </div>
<div style="padding-left:35.4pt;"> ldd raster2pgsql</div>
<div style="padding-left:35.4pt;"> ldd postgis-2.5.so #probably need to specify full path</div>
<div style="padding-left:35.4pt;"> </div>
<div style="padding-left:35.4pt;">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 style="padding-left:35.4pt;"> </div>
<div style="padding-left:35.4pt;">Depending on you mix of GDAL version and Proj. Those 2 might be incompatible.</div>
<div style="padding-left:35.4pt;"> </div>
<div style="padding-left:35.4pt;">GDAL < 3 should ideally be using a Proj < 6</div>
<div style="padding-left:35.4pt;">GDAL > 3 should be using proj >= 6 and by extension so should PostGIS.</div>
<div style="padding-left:35.4pt;">Both PostGIS and GDAL should be using the same version of proj otherwise bad things happen.</div>
<div> </div>
<div> Hi,</div>
<div> thank you Regina and Lars for your response.</div>
<div>I would precise i did never compil any packet.</div>
<div>Installation server history (Centos 8) : </div>
<div> postgres : (<a href="https://www.postgresql.org/download/linux/redhat/">https://www.postgresql.org/download/linux/redhat/</a>)</div>
<div> dnf -y install <a href="https://download.postgresql.org/pub/repos/yum/reporpms/EL-8-x86_64/pgdg-redhat-repo-latest.noarch.rpm">
https://download.postgresql.org/pub/repos/yum/reporpms/EL-8-x86_64/pgdg-redhat-repo-latest.noarch.rpm</a></div>
<div> dnf -qy module disable postgresql</div>
<div> dnf -y install postgresql12-server postgresql12-devel postgresql12-contrib </div>
<div> postgis : (<a href="https://computingforgeeks.com/how-to-install-postgis-on-centos-8-linux/">https://computingforgeeks.com/how-to-install-postgis-on-centos-8-linux/</a>)</div>
<div> dnf -y install <a href="https://dl.fedoraproject.org/pub/epel/epel-release-latest-8.noarch.rpm">
https://dl.fedoraproject.org/pub/epel/epel-release-latest-8.noarch.rpm</a></div>
<div> dnf config-manager --set-enabled PowerTools</div>
<div> dnf -y install postgis25_12 postgis25_12-docs postgis25_12-utils postgis25_12-client</div>
<div> </div>
<div>SELECT postgis_full_version() :</div>
<div> 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</div>
<div> </div>
<div>ldd /usr/pgsql-12/bin/raster2pgsql</div>
<div> linux-vdso.so.1 (0x00007ffe013cb000)</div>
<div> liblwgeom-2.5.so.0 => /usr/pgsql-12/lib/liblwgeom-2.5.so.0 (0x00007f222cedc000)</div>
<div> libgdal.so.27 => /usr/gdal31/lib/libgdal.so.27 (0x00007f222b4f1000)</div>
<div> libgeos_c.so.1 => /usr/geos38/lib64/libgeos_c.so.1 (0x00007f222b2b4000)</div>
<div> libc.so.6 => /lib64/libc.so.6 (0x00007f222aef2000)</div>
<div> libm.so.6 => /lib64/libm.so.6 (0x00007f222ab70000)</div>
<div> libproj.so.19 => /usr/proj71/lib/libproj.so.19 (0x00007f222a65d000)</div>
<div> libjson-c.so.4 => /lib64/libjson-c.so.4 (0x00007f222a44d000)</div>
<div> libSFCGAL.so.1 => /lib64/libSFCGAL.so.1 (0x00007f2229756000)</div>
<div> libarmadillo.so.9 => /lib64/libarmadillo.so.9 (0x00007f2229545000)</div>
<div> libpoppler.so.78 => /lib64/libpoppler.so.78 (0x00007f222905f000)</div>
<div> libfreexl.so.1 => /lib64/libfreexl.so.1 (0x00007f2228e55000)</div>
<div> libwebp.so.7 => /lib64/libwebp.so.7 (0x00007f2228be7000)</div>
<div> libodbc.so.2 => /lib64/libodbc.so.2 (0x00007f2228976000)</div>
<div> libodbcinst.so.2 => /lib64/libodbcinst.so.2 (0x00007f2228760000)</div>
<div> libexpat.so.1 => /lib64/libexpat.so.1 (0x00007f2228525000)</div>
<div> libxerces-c-3.2.so => /lib64/libxerces-c-3.2.so (0x00007f2227f52000)</div>
<div> libopenjp2.so.7 => /lib64/libopenjp2.so.7 (0x00007f2227d00000)</div>
<div> libjasper.so.4 => /lib64/libjasper.so.4 (0x00007f2227aa2000)</div>
<div> libnetcdf.so.15 => /lib64/libnetcdf.so.15 (0x00007f2227756000)</div>
<div> libhdf5.so.103 => /lib64/libhdf5.so.103 (0x00007f22271cb000)</div>
<div> libmfhdf.so.0 => /lib64/libmfhdf.so.0 (0x00007f2226fa2000)</div>
<div> libdf.so.0 => /lib64/libdf.so.0 (0x00007f2226cf9000)</div>
<div> libogdi.so.4 => /lib64/libogdi.so.4 (0x00007f2226adc000)</div>
<div> libgif.so.7 => /lib64/libgif.so.7 (0x00007f22268d2000)</div>
<div> libjpeg.so.62 => /lib64/libjpeg.so.62 (0x00007f2226669000)</div>
<div> libgeotiff.so.5 => /lib64/libgeotiff.so.5 (0x00007f2226435000)</div>
<div> libtiff.so.5 => /lib64/libtiff.so.5 (0x00007f22261bc000)</div>
<div> libgta.so.1 => /lib64/libgta.so.1 (0x00007f2225fb2000)</div>
<div> libpng16.so.16 => /lib64/libpng16.so.16 (0x00007f2225d7d000)</div>
<div> libcfitsio.so.7 => /lib64/libcfitsio.so.7 (0x00007f2225872000)</div>
<div> libpq.so.5 => /usr/pgsql-12/lib/libpq.so.5 (0x00007f2225623000)</div>
<div> libzstd.so.1 => /lib64/libzstd.so.1 (0x00007f2225381000)</div>
<div> liblzma.so.5 => /lib64/liblzma.so.5 (0x00007f222515a000)</div>
<div> libproj.so.15 => /lib64/libproj.so.15 (0x00007f2224c4a000)</div>
<div> libsqlite3.so.0 => /lib64/libsqlite3.so.0 (0x00007f2224937000)</div>
<div> librt.so.1 => /lib64/librt.so.1 (0x00007f222472e000)</div>
<div> libtirpc.so.3 => /lib64/libtirpc.so.3 (0x00007f22244fb000)</div>
<div> libdapclient.so.6 => /lib64/libdapclient.so.6 (0x00007f22242b1000)</div>
<div> libdapserver.so.7 => /lib64/libdapserver.so.7 (0x00007f22240a0000)</div>
<div> libdap.so.25 => /lib64/libdap.so.25 (0x00007f2223ce4000)</div>
<div> libspatialite.so.7 => /lib64/libspatialite.so.7 (0x00007f22234a9000)</div>
<div> libpcre.so.1 => /lib64/libpcre.so.1 (0x00007f2223238000)</div>
<div> libcurl.so.4 => /lib64/libcurl.so.4 (0x00007f2222faa000)</div>
<div> libxml2.so.2 => /lib64/libxml2.so.2 (0x00007f2222c42000)</div>
<div> libmariadb.so.3 => /lib64/libmariadb.so.3 (0x00007f22229f0000)</div>
<div> libz.so.1 => /lib64/libz.so.1 (0x00007f22227d9000)</div>
<div> libdl.so.2 => /lib64/libdl.so.2 (0x00007f22225d5000)</div>
<div> libpthread.so.0 => /lib64/libpthread.so.0 (0x00007f22223b5000)</div>
<div> libssl.so.1.1 => /lib64/libssl.so.1.1 (0x00007f2222121000)</div>
<div> libcrypto.so.1.1 => /lib64/libcrypto.so.1.1 (0x00007f2221c3e000)</div>
<div> libstdc++.so.6 => /lib64/libstdc++.so.6 (0x00007f22218a9000)</div>
<div> /lib64/ld-linux-x86-64.so.2 (0x00007f222d184000)</div>
<div> libgcc_s.so.1 => /lib64/libgcc_s.so.1 (0x00007f2221691000)</div>
<div> libgeos-3.8.1.so => /usr/geos38/lib64/libgeos-3.8.1.so (0x00007f22212bc000)</div>
<div> libCGAL_Core.so.13 => /usr/lib64/libCGAL_Core.so.13 (0x00007f222101c000)</div>
<div> libboost_thread.so.1.66.0 => /usr/lib64/libboost_thread.so.1.66.0 (0x00007f2220df0000)</div>
<div> libboost_system.so.1.66.0 => /usr/lib64/libboost_system.so.1.66.0 (0x00007f2220beb000)</div>
<div> libboost_serialization.so.1.66.0 => /usr/lib64/libboost_serialization.so.1.66.0 (0x00007f22209aa000)</div>
<div> libboost_chrono.so.1.66.0 => /usr/lib64/libboost_chrono.so.1.66.0 (0x00007f22207a1000)</div>
<div> libboost_date_time.so.1.66.0 => /usr/lib64/libboost_date_time.so.1.66.0 (0x00007f222058e000)</div>
<div> libboost_atomic.so.1.66.0 => /usr/lib64/libboost_atomic.so.1.66.0 (0x00007f222038c000)</div>
<div> libCGAL.so.13 => /usr/lib64/libCGAL.so.13 (0x00007f222016d000)</div>
<div> libmpfr.so.4 => /usr/lib64/libmpfr.so.4 (0x00007f221ff09000)</div>
<div> libgmp.so.10 => /usr/lib64/libgmp.so.10 (0x00007f221fc71000)</div>
<div> libopenblaso.so.0 => /lib64/libopenblaso.so.0 (0x00007f221df27000)</div>
<div> liblapack.so.3 => /lib64/liblapack.so.3 (0x00007f221d686000)</div>
<div> libsz.so.2 => /lib64/libsz.so.2 (0x00007f221d483000)</div>
<div> libarpack.so.2 => /lib64/libarpack.so.2 (0x00007f221d235000)</div>
<div> libsuperlu.so.5.1 => /lib64/libsuperlu.so.5.1 (0x00007f221cfbf000)</div>
<div> libfreetype.so.6 => /lib64/libfreetype.so.6 (0x00007f221cd03000)</div>
<div> libfontconfig.so.1 => /lib64/libfontconfig.so.1 (0x00007f221cabe000)</div>
<div> libsmime3.so => /lib64/libsmime3.so (0x00007f221c895000)</div>
<div> libnss3.so => /lib64/libnss3.so (0x00007f221c55f000)</div>
<div> libnspr4.so => /lib64/libnspr4.so (0x00007f221c31e000)</div>
<div> liblcms2.so.2 => /lib64/liblcms2.so.2 (0x00007f221c0c1000)</div>
<div> libltdl.so.7 => /lib64/libltdl.so.7 (0x00007f221beb7000)</div>
<div> libhdf5_hl.so.100 => /lib64/libhdf5_hl.so.100 (0x00007f221bc93000)</div>
<div> libjbig.so.2.1 => /lib64/libjbig.so.2.1 (0x00007f221ba87000)</div>
<div> libbz2.so.1 => /lib64/libbz2.so.1 (0x00007f221b876000)</div>
<div> libgssapi_krb5.so.2 => /lib64/libgssapi_krb5.so.2 (0x00007f221b626000)</div>
<div> libldap_r-2.4.so.2 => /lib64/libldap_r-2.4.so.2 (0x00007f221b3d0000)</div>
<div> libkrb5.so.3 => /lib64/libkrb5.so.3 (0x00007f221b0e0000)</div>
<div> libk5crypto.so.3 => /lib64/libk5crypto.so.3 (0x00007f221aec4000)</div>
<div> libcom_err.so.2 => /lib64/libcom_err.so.2 (0x00007f221acc0000)</div>
<div> libuuid.so.1 => /lib64/libuuid.so.1 (0x00007f221aab8000)</div>
<div> libnghttp2.so.14 => /lib64/libnghttp2.so.14 (0x00007f221a891000)</div>
<div> libidn2.so.0 => /lib64/libidn2.so.0 (0x00007f221a673000)</div>
<div> libssh.so.4 => /lib64/libssh.so.4 (0x00007f221a3e8000)</div>
<div> libpsl.so.5 => /lib64/libpsl.so.5 (0x00007f221a1d7000)</div>
<div> libldap-2.4.so.2 => /lib64/libldap-2.4.so.2 (0x00007f2219f8a000)</div>
<div> liblber-2.4.so.2 => /lib64/liblber-2.4.so.2 (0x00007f2219d7a000)</div>
<div> libbrotlidec.so.1 => /lib64/libbrotlidec.so.1 (0x00007f2219b6e000)</div>
<div> libgfortran.so.5 => /lib64/libgfortran.so.5 (0x00007f22196f1000)</div>
<div> libgomp.so.1 => /lib64/libgomp.so.1 (0x00007f22194b9000)</div>
<div> libblas.so.3 => /lib64/libblas.so.3 (0x00007f2219265000)</div>
<div> libaec.so.0 => /lib64/libaec.so.0 (0x00007f221905d000)</div>
<div> libopenblasp.so.0 => /lib64/libopenblasp.so.0 (0x00007f2217312000)</div>
<div> libquadmath.so.0 => /lib64/libquadmath.so.0 (0x00007f22170d1000)</div>
<div> libsatlas.so.3 => /usr/lib64/atlas/libsatlas.so.3 (0x00007f22162f6000)</div>
<div> libnssutil3.so => /lib64/libnssutil3.so (0x00007f22160c5000)</div>
<div> libplc4.so => /lib64/libplc4.so (0x00007f2215ec0000)</div>
<div> libplds4.so => /lib64/libplds4.so (0x00007f2215cbc000)</div>
<div> libkrb5support.so.0 => /lib64/libkrb5support.so.0 (0x00007f2215aab000)</div>
<div> libkeyutils.so.1 => /lib64/libkeyutils.so.1 (0x00007f22158a7000)</div>
<div> libresolv.so.2 => /lib64/libresolv.so.2 (0x00007f2215690000)</div>
<div> libsasl2.so.3 => /lib64/libsasl2.so.3 (0x00007f2215472000)</div>
<div> libunistring.so.2 => /lib64/libunistring.so.2 (0x00007f22150f1000)</div>
<div> libbrotlicommon.so.1 => /lib64/libbrotlicommon.so.1 (0x00007f2214ed1000)</div>
<div> libselinux.so.1 => /lib64/libselinux.so.1 (0x00007f2214ca6000)</div>
<div> libcrypt.so.1 => /lib64/libcrypt.so.1 (0x00007f2214a7d000)</div>
<div> libpcre2-8.so.0 => /lib64/libpcre2-8.so.0 (0x00007f22147f9000)</div>
<div> </div>
<div>ldd /usr/pgsql-12/lib/postgis-2.5.so</div>
<div> linux-vdso.so.1 (0x00007fff426f6000)</div>
<div> libgeos_c.so.1 => /usr/geos38/lib64/libgeos_c.so.1 (0x00007f9c081b7000)</div>
<div> libproj.so.15 => /lib64/libproj.so.15 (0x00007f9c07ca7000)</div>
<div> libjson-c.so.4 => /lib64/libjson-c.so.4 (0x00007f9c07a97000)</div>
<div> libprotobuf-c.so.1 => /lib64/libprotobuf-c.so.1 (0x00007f9c0788e000)</div>
<div> libxml2.so.2 => /lib64/libxml2.so.2 (0x00007f9c07526000)</div>
<div> libm.so.6 => /lib64/libm.so.6 (0x00007f9c071a4000)</div>
<div> libSFCGAL.so.1 => /lib64/libSFCGAL.so.1 (0x00007f9c064ad000)</div>
<div> libc.so.6 => /lib64/libc.so.6 (0x00007f9c060eb000)</div>
<div> libgeos-3.8.1.so => /usr/geos38/lib64/libgeos-3.8.1.so (0x00007f9c05d16000)</div>
<div> libstdc++.so.6 => /lib64/libstdc++.so.6 (0x00007f9c05981000)</div>
<div> libgcc_s.so.1 => /lib64/libgcc_s.so.1 (0x00007f9c05769000)</div>
<div> libsqlite3.so.0 => /lib64/libsqlite3.so.0 (0x00007f9c05456000)</div>
<div> libpthread.so.0 => /lib64/libpthread.so.0 (0x00007f9c05236000)</div>
<div> /lib64/ld-linux-x86-64.so.2 (0x00007f9c086e0000)</div>
<div> libdl.so.2 => /lib64/libdl.so.2 (0x00007f9c05032000)</div>
<div> libz.so.1 => /lib64/libz.so.1 (0x00007f9c04e1b000)</div>
<div> liblzma.so.5 => /lib64/liblzma.so.5 (0x00007f9c04bf4000)</div>
<div> libCGAL_Core.so.13 => /usr/lib64/libCGAL_Core.so.13 (0x00007f9c04954000)</div>
<div> libboost_thread.so.1.66.0 => /usr/lib64/libboost_thread.so.1.66.0 (0x00007f9c04728000)</div>
<div> libboost_system.so.1.66.0 => /usr/lib64/libboost_system.so.1.66.0 (0x00007f9c04523000)</div>
<div> libboost_serialization.so.1.66.0 => /usr/lib64/libboost_serialization.so.1.66.0 (0x00007f9c042e2000)</div>
<div> libboost_chrono.so.1.66.0 => /usr/lib64/libboost_chrono.so.1.66.0 (0x00007f9c040d9000)</div>
<div> libboost_date_time.so.1.66.0 => /usr/lib64/libboost_date_time.so.1.66.0 (0x00007f9c03ec6000)</div>
<div> libboost_atomic.so.1.66.0 => /usr/lib64/libboost_atomic.so.1.66.0 (0x00007f9c03cc4000)</div>
<div> libCGAL.so.13 => /usr/lib64/libCGAL.so.13 (0x00007f9c03aa5000)</div>
<div> libmpfr.so.4 => /usr/lib64/libmpfr.so.4 (0x00007f9c03841000)</div>
<div> libgmp.so.10 => /usr/lib64/libgmp.so.10 (0x00007f9c035a9000)</div>
<div> librt.so.1 => /usr/lib64/librt.so.1 (0x00007f9c033a0000)</div>
<div> </div>
<div>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 :</div>
<div> ERROR: could not load library "/usr/pgsql-12/lib/rtpostgis-2.5.so": /usr/gdal31/lib/libgdal.so.27: undefined symbol: GTIFGetGCSInfoEx </div>
<div>I can precise dnf list installed | grep gdal show :</div>
<div> gdal30-libs.x86_64 3.0.4-4.rhel8 @pgdg-common</div>
<div> gdal31-libs.x86_64 3.1.3-1.rhel8 @pgdg-common </div>
<div>Have a nice day and thanks for your help.</div>
<div>Alain.</div>
<div> </div>
</span></font>
</body>
</html>