<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 style=""><br>
</div>
<div>
<div id="appendonsend"></div>
<div style=""><br>
</div>
<hr tabindex="-1" style="display:inline-block; width:98%">
<div id="divRplyFwdMsg" dir="ltr"></div>
<span style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">>From: postgis-users <postgis-users-bounces@lists.osgeo.org> on behalf of Alain Benard <alain.benard@inrae.fr>Sent: Monday, November 2, 2020 9:17 AMTo: postgis-users@lists.osgeo.org
<postgis-users@lists.osgeo.org>Subject: [postgis-users] Problem raster2pgsql on Centos 8 - postgres 12 / postgis 2.5</span>
<div><span style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">>
</span></div>
<div><span style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">></span></div>
<div><span style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">>Hi ,</span></div>
<div><span style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">></span></div>
<div><span style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">>I have a problem with rasterpgsql with all file geotiff.</span></div>
<div><span style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">></span></div>
<div><span style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">>
</span></div>
<div><span style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">></span></div>
<div><span style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">>On a server Centos 7 / Postgres 9.5 / postgis 2.5 :</span></div>
<div><span style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">></span></div>
<div><span style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">>/usr/pgsql-9.5/bin/raster2pgsql -b 1 -I -C -F -t 50x50 -s 2154 filename.geotiff tablename > script.sql : it’s OK.</span></div>
<div><span style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">></span></div>
<div><span style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">>
</span></div>
<div><span style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">></span></div>
<div><span style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">>On a server Centos 8 / Postgres 12 / postgis 2.5 : (with the same geotiff file)</span></div>
<div><span style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">></span></div>
<div><span style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">> /usr/pgsql-12/bin/raster2pgsql -b 1 -I -C -F -t 50x50 -s 2154 filename.geotiff tablename > script.sql : error</span></div>
<div><span style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">></span></div>
<div><span style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">>The script.sql file is not completed and the error is :</span></div>
<div><span style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">></span></div>
<div><span style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">> free(): invalid pointer</span></div>
<div><span style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">></span></div>
<div><span style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">>Abandon (core dumped)</span></div>
<div><span style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">></span></div>
<div><span style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">>I search on the web but nobody give solution (except work on Centos 7 L)</span></div>
<div><span style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">></span></div>
<div><span style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">>Thanks for advance.</span></div>
<div><span style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">></span></div>
<div><span style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">>Alain.</span></div>
<div><span style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">></span></div>
<div><span style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">></span></div>
<br>
<div lang="FR">
<div>
<p style="margin: 0cm 0cm 0.0001pt;"><span style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">Here is some info for the same problem related but for Postgis 3.0</span><br>
</p>
<p style="margin: 0cm 0cm 0.0001pt;"><br>
</p>
<p style="margin: 0cm 0cm 0.0001pt;"></p>
<div style=""><a href="https://www.postgresql-archive.org/free-invalid-pointer-when-to-dumping-data-to-a-new-server-td6159235.html"><span style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">https://www.postgresql-archive.org/free-invalid-pointer-when-to-dumping-data-to-a-new-server-td6159235.html</span></a><br>
</div>
<div style=""><a href="https://trac.osgeo.org/postgis/ticket/4779"><span style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">https://trac.osgeo.org/postgis/ticket/4779</span></a><br>
</div>
<div style=""><a href="https://redmine.postgresql.org/issues/5961"><span style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">https://redmine.postgresql.org/issues/5961</span></a></div>
<div style=""><br>
</div>
<span style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">Lars</span><br>
<p></p>
<p style="margin: 0cm 0cm 0.0001pt;"><span style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);"> </span></p>
<p style="margin: 0cm 0cm 0.0001pt;"><span style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);"> </span></p>
<table cellspacing="0" cellpadding="0" border="0">
<tbody>
<tr>
<td style="padding:0cm 0cm 0cm 0cm">
<p style="margin: 0cm 0cm 0.0001pt;"><a href="http://www.inra.fr/"><img alt="INRA" title="" style="width:1.5312in; height:.625in" width="147" height="60" border="0" data-outlook-trace="F:1|T:1" src="cid:32757b7e-5c56-4f0b-9889-ca5ed9a97ab6"></a></p>
</td>
</tr>
<tr>
<td style="padding:0cm 0cm 0cm 0cm"><br>
</td>
</tr>
</tbody>
</table>
<p style="margin: 0cm 0cm 0.0001pt;"><span style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);"> </span></p>
<p style="margin: 0cm 0cm 0.0001pt;"><span style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);"> </span></p>
</div>
</div>
</div>
</body>
</html>