<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii"><meta name=Generator content="Microsoft Word 15 (filtered medium)"><!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman",serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p
{mso-style-priority:99;
margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman",serif;}
span.EmailStyle18
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=EN-US link=blue vlink=purple><div class=WordSection1><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>Sounds from the below thread the issue is with proj and the interaction with GDAL.<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>Can both of you let me know what the output of<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>SELECT postgis_full_version()l<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>Gives – and also do an <o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>ldd raster2pgsql<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>ldd postgis-2.5.so #probably need to specify full path<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>There have been many changes in proj and while we patched it in for general postgis vector use in 3.0, 3.1+ <o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>Depending on you mix of GDAL version and Proj. Those 2 might be incompatible.<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>GDAL < 3 should ideally be using a Proj < 6<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>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.<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'><o:p> </o:p></span></p><div style='border:none;border-left:solid blue 1.5pt;padding:0in 0in 0in 4.0pt'><div><div style='border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in'><p class=MsoNormal><b><span style='font-size:11.0pt;font-family:"Calibri",sans-serif'>From:</span></b><span style='font-size:11.0pt;font-family:"Calibri",sans-serif'> postgis-users [mailto:postgis-users-bounces@lists.osgeo.org] <b>On Behalf Of </b>Lars Aksel Opsahl<br><b>Sent:</b> Monday, November 2, 2020 4:29 AM<br><b>To:</b> postgis-users@lists.osgeo.org<br><b>Subject:</b> Re: [postgis-users] Problem raster2pgsql on Centos 8 - postgres 12 / postgis 2.5<o:p></o:p></span></p></div></div><p class=MsoNormal><o:p> </o:p></p><div><p class=MsoNormal><o:p> </o:p></p></div><div><div><p class=MsoNormal><o:p> </o:p></p></div><div class=MsoNormal align=center style='text-align:center'><hr size=2 width="98%" align=center></div><p class=MsoNormal><span style='font-family:"Calibri",sans-serif;color:black'>>From: postgis-users <<a href="mailto:postgis-users-bounces@lists.osgeo.org">postgis-users-bounces@lists.osgeo.org</a>> on behalf of Alain Benard <<a href="mailto:alain.benard@inrae.fr">alain.benard@inrae.fr</a>>Sent: Monday, November 2, 2020 9:17 AMTo: <a href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a> <<a href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a>>Subject: [postgis-users] Problem raster2pgsql on Centos 8 - postgres 12 / postgis 2.5</span> <o:p></o:p></p><div><p class=MsoNormal><span style='font-family:"Calibri",sans-serif;color:black'>> </span><o:p></o:p></p></div><div><p class=MsoNormal><span style='font-family:"Calibri",sans-serif;color:black'>></span><o:p> </o:p></p></div><div><p class=MsoNormal><span style='font-family:"Calibri",sans-serif;color:black'>>Hi ,</span><o:p></o:p></p></div><div><p class=MsoNormal><span style='font-family:"Calibri",sans-serif;color:black'>></span><o:p> </o:p></p></div><div><p class=MsoNormal><span style='font-family:"Calibri",sans-serif;color:black'>>I have a problem with rasterpgsql with all file geotiff.</span><o:p></o:p></p></div><div><p class=MsoNormal><span style='font-family:"Calibri",sans-serif;color:black'>></span><o:p> </o:p></p></div><div><p class=MsoNormal><span style='font-family:"Calibri",sans-serif;color:black'>> </span><o:p></o:p></p></div><div><p class=MsoNormal><span style='font-family:"Calibri",sans-serif;color:black'>></span><o:p> </o:p></p></div><div><p class=MsoNormal><span style='font-family:"Calibri",sans-serif;color:black'>>On a server Centos 7 / Postgres 9.5 / postgis 2.5 :</span><o:p></o:p></p></div><div><p class=MsoNormal><span style='font-family:"Calibri",sans-serif;color:black'>></span><o:p> </o:p></p></div><div><p class=MsoNormal><span style='font-family:"Calibri",sans-serif;color:black'>>/usr/pgsql-9.5/bin/raster2pgsql -b 1 -I -C -F -t 50x50 -s 2154 filename.geotiff tablename > script.sql : it’s OK.</span><o:p></o:p></p></div><div><p class=MsoNormal><span style='font-family:"Calibri",sans-serif;color:black'>></span><o:p> </o:p></p></div><div><p class=MsoNormal><span style='font-family:"Calibri",sans-serif;color:black'>> </span><o:p></o:p></p></div><div><p class=MsoNormal><span style='font-family:"Calibri",sans-serif;color:black'>></span><o:p> </o:p></p></div><div><p class=MsoNormal><span style='font-family:"Calibri",sans-serif;color:black'>>On a server Centos 8 / Postgres 12 / postgis 2.5 : (with the same geotiff file)</span><o:p></o:p></p></div><div><p class=MsoNormal><span style='font-family:"Calibri",sans-serif;color:black'>></span><o:p> </o:p></p></div><div><p class=MsoNormal><span style='font-family:"Calibri",sans-serif;color:black'>> /usr/pgsql-12/bin/raster2pgsql -b 1 -I -C -F -t 50x50 -s 2154 filename.geotiff tablename > script.sql : error</span><o:p></o:p></p></div><div><p class=MsoNormal><span style='font-family:"Calibri",sans-serif;color:black'>></span><o:p> </o:p></p></div><div><p class=MsoNormal><span style='font-family:"Calibri",sans-serif;color:black'>>The script.sql file is not completed and the error is :</span><o:p></o:p></p></div><div><p class=MsoNormal><span style='font-family:"Calibri",sans-serif;color:black'>></span><o:p> </o:p></p></div><div><p class=MsoNormal><span style='font-family:"Calibri",sans-serif;color:black'>> free(): invalid pointer</span><o:p></o:p></p></div><div><p class=MsoNormal><span style='font-family:"Calibri",sans-serif;color:black'>></span><o:p> </o:p></p></div><div><p class=MsoNormal><span style='font-family:"Calibri",sans-serif;color:black'>>Abandon (core dumped)</span><o:p></o:p></p></div><div><p class=MsoNormal><span style='font-family:"Calibri",sans-serif;color:black'>></span><o:p> </o:p></p></div><div><p class=MsoNormal><span style='font-family:"Calibri",sans-serif;color:black'>>I search on the web but nobody give solution (except work on Centos 7 L)</span><o:p></o:p></p></div><div><p class=MsoNormal><span style='font-family:"Calibri",sans-serif;color:black'>></span><o:p> </o:p></p></div><div><p class=MsoNormal><span style='font-family:"Calibri",sans-serif;color:black'>>Thanks for advance.</span><o:p></o:p></p></div><div><p class=MsoNormal><span style='font-family:"Calibri",sans-serif;color:black'>></span><o:p> </o:p></p></div><div><p class=MsoNormal><span style='font-family:"Calibri",sans-serif;color:black'>>Alain.</span><o:p></o:p></p></div><div><p class=MsoNormal><span style='font-family:"Calibri",sans-serif;color:black'>></span><o:p> </o:p></p></div><div><p class=MsoNormal><span style='font-family:"Calibri",sans-serif;color:black'>></span><o:p> </o:p></p></div><p class=MsoNormal><o:p> </o:p></p><div><div><p><span lang=FR style='font-family:"Calibri",sans-serif;color:black'>Here is some info for the same problem related but for Postgis 3.0</span><span lang=FR><o:p></o:p></span></p><p><span lang=FR><o:p> </o:p></span></p><div><p class=MsoNormal><span lang=FR><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",sans-serif;color:black'>https://www.postgresql-archive.org/free-invalid-pointer-when-to-dumping-data-to-a-new-server-td6159235.html</span></a><o:p></o:p></span></p></div><div><p class=MsoNormal><span lang=FR><a href="https://trac.osgeo.org/postgis/ticket/4779"><span style='font-family:"Calibri",sans-serif;color:black'>https://trac.osgeo.org/postgis/ticket/4779</span></a><o:p></o:p></span></p></div><div><p class=MsoNormal><span lang=FR><a href="https://redmine.postgresql.org/issues/5961"><span style='font-family:"Calibri",sans-serif;color:black'>https://redmine.postgresql.org/issues/5961</span></a><o:p></o:p></span></p></div><div><p class=MsoNormal><span lang=FR><o:p> </o:p></span></p></div><p class=MsoNormal><span lang=FR style='font-family:"Calibri",sans-serif;color:black'>Lars</span><span lang=FR><o:p></o:p></span></p><p><span lang=FR style='font-family:"Calibri",sans-serif;color:black'> </span><span lang=FR><o:p></o:p></span></p><p><span lang=FR style='font-family:"Calibri",sans-serif;color:black'> </span><span lang=FR><o:p></o:p></span></p><table class=MsoNormalTable border=0 cellspacing=0 cellpadding=0><tr><td style='padding:0in 0in 0in 0in'><p><a href="http://www.inra.fr/"><span style='text-decoration:none'><img border=0 width=147 height=60 id="_x0000_i1026" src="cid:image001.png@01D6B2CC.AEB02420" alt=INRA></span></a><o:p></o:p></p></td></tr><tr><td style='padding:0in 0in 0in 0in'></td></tr></table><p><span lang=FR style='font-family:"Calibri",sans-serif;color:black'> </span><span lang=FR><o:p></o:p></span></p><p><span lang=FR style='font-family:"Calibri",sans-serif;color:black'> </span><span lang=FR><o:p></o:p></span></p></div></div></div></div></div></body></html>