<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>Date: <b><u>Fri, 13 Nov</u></b> 2020 23:53:00 +0000</div>
<div>From: Devrim Gündüz <<a href="mailto:devrim@gunduz.org">devrim@gunduz.org</a>></div>
<div>To: PostGIS Users Discussion <<a href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a>></div>
<div>Subject: Re: [postgis-users] Problem raster2pgsql on Centos 8 -</div>
<div> postgres 12 / postgis 2.5</div>
<div>Hi,</div>
<div style="padding-left:35.4pt;">On Mon, 2020-11-02 at 08:17 +0000, Alain Benard wrote:</div>
<div style="padding-left:70.8pt;">> I have a problem with rasterpgsql with all file geotiff.</div>
<div style="padding-left:70.8pt;">> </div>
<div style="padding-left:70.8pt;">> On a server Centos 7 / Postgres 9.5 / postgis 2.5 :</div>
<div style="padding-left:70.8pt;">> /usr/pgsql-9.5/bin/raster2pgsql -b 1 -I -C -F -t 50x50 -s 2154 </div>
<div style="padding-left:70.8pt;">> filename.geotiff tablename > script.sql : it's OK.</div>
<div style="padding-left:70.8pt;">> </div>
<div style="padding-left:70.8pt;">> On a server Centos 8 / Postgres 12 / postgis 2.5 : (with the same </div>
<div style="padding-left:70.8pt;">> geotiff file)</div>
<div style="padding-left:70.8pt;">> /usr/pgsql-12/bin/raster2pgsql -b 1 -I -C -F -t 50x50 </div>
<div style="padding-left:70.8pt;">> -s 2154 filename.geotiff tablename > script.sql : error The </div>
<div style="padding-left:70.8pt;">> script.sql file is not completed and the error is :</div>
<div style="padding-left:70.8pt;">> free(): invalid pointer Abandon (core dumped)</div>
<div style="padding-left:35.4pt;"> </div>
<div style="padding-left:35.4pt;">Can you please fully update the packages? It should pick up PROJ 7.2.0, GDAL 3.2.0, etc. This was a RPM packaging issue, and should be fixed now.</div>
<div style="padding-left:35.4pt;"> </div>
<div style="padding-left:35.4pt;">Also, can you please remove OS-supplied PROJ packages as well?</div>
<div style="padding-left:35.4pt;"> </div>
<div style="padding-left:35.4pt;">dnf remove proj-*</div>
<div style="padding-left:35.4pt;"> </div>
<div style="padding-left:35.4pt;">Regards,</div>
<div style="padding-left:35.4pt;">--</div>
<div style="padding-left:35.4pt;">Devrim Gündüz</div>
<div> </div>
<div>on <b><u>16/11/2020</u></b> I wrote :</div>
<div style="padding-left:35.4pt;">Hi,</div>
<div style="padding-left:35.4pt;">In my case the problem persist. Perhaps i use an other depot.</div>
<div style="padding-left:35.4pt;">For installing postgres postgis on a new virtual machine with Centos 8 i use a script:</div>
<div style="padding-left:35.4pt;"> (<a href="https://computingforgeeks.com/how-to-install-postgresql-12-on-centos-7/"><font color="#0563C1"><u>https://computingforgeeks.com/how-to-install-postgresql-12-on-centos-7/</u></font></a>)</div>
<div style="padding-left:35.4pt;"> (<a href="https://computingforgeeks.com/how-to-install-postgis-on-centos-8-linux/"><font color="#0563C1"><u>https://computingforgeeks.com/how-to-install-postgis-on-centos-8-linux/</u></font></a>)</div>
<div style="padding-left:35.4pt;"> The principals commands are :</div>
<div style="padding-left:70.8pt;">dnf -y install <a href="https://download.postgresql.org/pub/repos/yum/reporpms/EL-8-x86_64/pgdg-redhat-repo-latest.noarch.rpm"><font color="#0563C1"><u>https://download.postgresql.org/pub/repos/yum/reporpms/EL-8-x86_64/pgdg-redhat-repo-latest.noarch.rpm</u></font></a></div>
<div style="padding-left:70.8pt;">dnf -qy module disable postgresql</div>
<div style="padding-left:70.8pt;">dnf -y install postgresql12-server postgresql12-devel postgresql12-contrib</div>
<div style="padding-left:70.8pt;">dnf -y install <a href="https://dl.fedoraproject.org/pub/epel/epel-release-latest-8.noarch.rpm"><font color="#0563C1"><u>https://dl.fedoraproject.org/pub/epel/epel-release-latest-8.noarch.rpm</u></font></a></div>
<div style="padding-left:70.8pt;">dnf config-manager --set-enabled PowerTools</div>
<div style="padding-left:70.8pt;">dnf -y install postgis25_12 postgis25_12-docs postgis25_12-utils postgis25_12-client</div>
<div style="padding-left:70.8pt;"> </div>
<div style="padding-left:35.4pt;"><b>Two version of proj are installed</b> with the script (even if i erase proj before with ' dnf remove proj-*') :</div>
<div style="padding-left:35.4pt;"> dnf list installed |grep proj </div>
<div style="padding-left:35.4pt;"> proj.x86_64 6.3.2-4.el8 @epel</div>
<div style="padding-left:35.4pt;"> proj72.x86_64 7.2.0-1.rhel8 @pgdg-common</div>
<div style="padding-left:35.4pt;"> </div>
<div style="padding-left:35.4pt;">The result : I can't use 'CREATE EXTENSION POSTGIS' : </div>
<div style="padding-left:35.4pt;"> ERREUR: n'a pas pu charger la bibliothèque « /usr/pgsql-12/lib/rtpostgis-2.5.so » : /usr/gdal32/lib/libgdal.so.28: undefined symbol: GTIFGetGCSInfoEx</div>
<div style="padding-left:35.4pt;">Thank you for explaining.</div>
<div style="padding-left:35.4pt;">Alain.</div>
<div> </div>
<div><b><u>Today (18/11/2020)</u></b> I try to reinstall on a new virtual machine with Centos 8. </div>
<div> dnf upgrade</div>
<div style="padding-left:35.4pt;">dnf -y install <a href="https://download.postgresql.org/pub/repos/yum/reporpms/EL-8-x86_64/pgdg-redhat-repo-latest.noarch.rpm"><font color="#0563C1"><u>https://download.postgresql.org/pub/repos/yum/reporpms/EL-8-x86_64/pgdg-redhat-repo-latest.noarch.rpm</u></font></a></div>
<div style="padding-left:35.4pt;">dnf -qy module disable postgresql</div>
<div style="padding-left:35.4pt;">dnf -y install postgresql12-server postgresql12-devel postgresql12-contrib</div>
<div style="padding-left:35.4pt;">dnf -y install <a href="https://dl.fedoraproject.org/pub/epel/epel-release-latest-8.noarch.rpm"><font color="#0563C1"><u>https://dl.fedoraproject.org/pub/epel/epel-release-latest-8.noarch.rpm</u></font></a></div>
<div style="padding-left:35.4pt;">dnf install dnf-plugins-core</div>
<div style="padding-left:35.4pt;">dnf config-manager --set-enabled PowerTools</div>
<div style="padding-left:35.4pt;">dnf install postgis25_12</div>
<div style="padding-left:35.4pt;"> </div>
<div style="padding-left:35.4pt;">I created a database and ‘CREATE EXTENSION POSTGIS ;’ failed :</div>
<div style="padding-left:70.8pt;">ERREUR: n'a pas pu charger la bibliothèque « /usr/pgsql-12/lib/rtpostgis-2.5.so » : /usr/gdal32/lib/libgdal.so.28: undefined symbol: GTIFGetGCSInfoEx</div>
<div style="padding-left:35.4pt;">ldd /usr/pgsql-12/lib/rtpostgis-2.5.so |grep proj</div>
<div> libproj.so.19 => /usr/proj72/lib/libproj.so.19 (0x00007ff4cfa59000)</div>
<div> libproj.so.15 => /lib64/libproj.so.15 (0x00007ff4c08c5000)</div>
<div> </div>
<div>It’s easy to reproduce this problem. The repository is corrupted and it’s impossible to install from it. I don’t know if this problem take a response on this list but we have some server without update because of this problem.</div>
<div>Thanks for advance.</div>
<div>Alain.</div>
<div> </div>
</span></font>
</body>
</html>