<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=iso-8859-1">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<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;}
@font-face
{font-family:Verdana;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:Aptos;}
@font-face
{font-family:"Segoe UI";
panose-1:2 11 5 2 4 2 4 2 2 3;}
@font-face
{font-family:"var\(--ff-mono\)";}
@font-face
{font-family:inherit;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
font-size:11.0pt;
font-family:"Aptos",sans-serif;
mso-ligatures:standardcontextual;
mso-fareast-language:EN-US;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#467886;
text-decoration:underline;}
code
{mso-style-priority:99;
font-family:"Courier New";}
span.EmailStyle22
{mso-style-type:personal-reply;
font-family:"Aptos",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;
mso-ligatures:none;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
/* List Definitions */
@list l0
{mso-list-id:380715435;
mso-list-template-ids:164384494;}
@list l0:level1
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l0:level2
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:1.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l0:level3
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:1.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l0:level4
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:2.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l0:level5
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:2.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l0:level6
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:3.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l0:level7
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:3.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l0:level8
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:4.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l0:level9
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:4.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l1
{mso-list-id:1867595829;
mso-list-template-ids:-4037324;}
@list l1:level1
{mso-level-tab-stop:.5in;
mso-level-number-position:left;
text-indent:-.25in;}
@list l1:level2
{mso-level-tab-stop:1.0in;
mso-level-number-position:left;
text-indent:-.25in;}
@list l1:level3
{mso-level-tab-stop:1.5in;
mso-level-number-position:left;
text-indent:-.25in;}
@list l1:level4
{mso-level-tab-stop:2.0in;
mso-level-number-position:left;
text-indent:-.25in;}
@list l1:level5
{mso-level-tab-stop:2.5in;
mso-level-number-position:left;
text-indent:-.25in;}
@list l1:level6
{mso-level-tab-stop:3.0in;
mso-level-number-position:left;
text-indent:-.25in;}
@list l1:level7
{mso-level-tab-stop:3.5in;
mso-level-number-position:left;
text-indent:-.25in;}
@list l1:level8
{mso-level-tab-stop:4.0in;
mso-level-number-position:left;
text-indent:-.25in;}
@list l1:level9
{mso-level-tab-stop:4.5in;
mso-level-number-position:left;
text-indent:-.25in;}
ol
{margin-bottom:0in;}
ul
{margin-bottom:0in;}
--></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-ZA" link="#467886" vlink="purple" style="word-wrap:break-word">
<div class="WordSection1">
<p class="MsoNormal">Hi Jorge,<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Yes I can confirm that I only have one GDAL library installed.
<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">The output of `dnf list –installed | grep gdal`<o:p></o:p></p>
<p class="MsoNormal">gdal310-libs.x86_64 3.10.1-1PGDG.rhel9 @pgdg-common<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">And this is the same version that is given when running `select postgis_full_version();` in psql:<o:p></o:p></p>
<p class="MsoNormal">POSTGIS="3.3.8 cfb70d6" [EXTENSION] PGSQL="150" GEOS="3.13.0-CAPI-1.19.0" PROJ="9.5.1" GDAL="GDAL 3.10.1, released 2025/01/08" LIBXML="2.9.13" LIBJ<o:p></o:p></p>
<p class="MsoNormal">SON="0.14" LIBPROTOBUF="1.3.3" WAGYU="0.5.0 (Internal)" RASTER<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Best Regards<o:p></o:p></p>
<p class="MsoNormal">Sean<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b><span lang="EN-US" style="font-family:"Calibri",sans-serif;mso-ligatures:none;mso-fareast-language:EN-ZA">From:</span></b><span lang="EN-US" style="font-family:"Calibri",sans-serif;mso-ligatures:none;mso-fareast-language:EN-ZA"> Jorge
Gustavo Rocha <jgr@di.uminho.pt> <br>
<b>Sent:</b> Wednesday, February 5, 2025 4:07 PM<br>
<b>To:</b> postgis-users@lists.osgeo.org<br>
<b>Subject:</b> Re: Error on raster2pgsq - rt_band_from_wkb: Premature end of WKB on band offline path reading.<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" align="left" width="100%" style="width:100.0%">
<tbody>
<tr>
<td width="0" style="width:.3pt;background:#A6A6A6;padding:5.25pt 1.5pt 5.25pt 1.5pt">
</td>
<td width="100%" style="width:100.0%;background:#EAEAEA;padding:5.25pt 3.75pt 5.25pt 11.25pt;aspect-ratio: revert !important;background:revert !important;block-size: revert !important;border:revert !important;bottom: revert !important;color:revert !important;color-scheme: revert !important;content-visibility: revert !important;cursor:revert !important;direction:revert !important;display:revert !important;font-size:revert !important;height:revert !important;hyphens: revert !important;letter-spacing:revert !important;line-height:revert !important;margin:revert !important;opacity: revert !important;order: revert !important;outline: revert !important;overflow:revert !important;padding:revert !important;position:revert !important;resize: revert !important;rotate: revert !important;scale: revert !important;tab-size: revert !important;table-layout:revert !important;text-align:revert !important;text-indent:revert !important;text-orientation: revert !important;text-overflow: revert !important;text-shadow:revert !important;text-transform:revert !important;text-wrap: revert !important;top:revert !important;transition: revert !important;user-select: revert !important;vertical-align:revert !important;visibility:revert !important;white-space:revert !important;width:revert !important;word-break:revert !important;word-spacing:revert !important;writing-mode:revert !important;zoom: revert !important">
<div>
<p class="MsoNormal" style="mso-element:frame;mso-element-frame-hspace:2.25pt;mso-element-wrap:around;mso-element-anchor-vertical:paragraph;mso-element-anchor-horizontal:column;mso-height-rule:exactly">
<span style="font-size:9.0pt;font-family:"Segoe UI",sans-serif;color:#212121">You don't often get email from
<a href="mailto:jgr@di.uminho.pt">jgr@di.uminho.pt</a>. <a href="https://aka.ms/LearnAboutSenderIdentification">
Learn why this is important</a> <o:p></o:p></span></p>
</div>
</td>
<td width="75" style="width:56.25pt;background:#EAEAEA;padding:5.25pt 3.75pt 5.25pt 3.75pt;aspect-ratio: revert !important;background:revert !important;block-size: revert !important;border:revert !important;bottom: revert !important;color:revert !important;color-scheme: revert !important;content-visibility: revert !important;cursor:revert !important;direction:revert !important;display:revert !important;font-size:revert !important;height:revert !important;hyphens: revert !important;letter-spacing:revert !important;line-height:revert !important;margin:revert !important;opacity: revert !important;order: revert !important;outline: revert !important;overflow:revert !important;padding:revert !important;position:revert !important;resize: revert !important;rotate: revert !important;scale: revert !important;tab-size: revert !important;table-layout:revert !important;text-align:revert !important;text-indent:revert !important;text-orientation: revert !important;text-overflow: revert !important;text-shadow:revert !important;text-transform:revert !important;text-wrap: revert !important;top:revert !important;transition: revert !important;user-select: revert !important;vertical-align:revert !important;visibility:revert !important;white-space:revert !important;width:revert !important;word-break:revert !important;word-spacing:revert !important;writing-mode:revert !important;zoom: revert !important;align: left !important">
</td>
</tr>
</tbody>
</table>
<div>
<div style="border:solid #9C6500 1.0pt;padding:2.0pt 2.0pt 2.0pt 2.0pt">
<p class="MsoNormal" style="line-height:12.0pt;background:#FFEB9C"><span style="font-size:10.0pt;font-family:"Calibri",sans-serif;color:black">CAUTION: This email originated from outside the Stellenbosch University network. Do not click links or open attachments
unless you recognize the sender and know the content is safe.<o:p></o:p></span></p>
</div>
<p class="MsoNormal"><span style="font-size:12.0pt"><o:p> </o:p></span></p>
<div>
<p>Hi <span lang="EN-US">Sean,</span><o:p></o:p></p>
<p><span lang="EN-US">Make sure you don't have dangling gdal libraries around. Maybe after upgrading, you still have old GDAL libraries.</span><o:p></o:p></p>
<p><span lang="EN-US">Can you confirm that you have only one GDAL library?</span><o:p></o:p></p>
<p><span lang="EN-US">Best regards,</span><o:p></o:p></p>
<p><span lang="EN-US">Jorge</span><o:p></o:p></p>
<div>
<p class="MsoNormal">On 05/02/25 12:32, Chater, ST, Mnr [schater--- via postgis-users wrote:<o:p></o:p></p>
</div>
<blockquote style="margin-top:5.0pt;margin-bottom:5.0pt">
<p class="MsoNormal"><span lang="EN-US">Hi,</span><o:p></o:p></p>
<p class="MsoNormal"><span lang="EN-US"> </span><o:p></o:p></p>
<p class="MsoNormal">I am trying to ingest an out-DB raster into PostgreSQL 15 database using the raster2pgsql command. I have PostGIS 3.3.8 installed (recently upgraded from 3.2). This server is running Rocky Linux (will refer to this as server A). Please
note this server is running a production application so I would prefer not to have to uninstall everything and restart from scratch.<o:p></o:p></p>
<p class="MsoNormal">This is the command I have used in the past and have been using now:<o:p></o:p></p>
<p class="MsoNormal"> <o:p></o:p></p>
<p class="MsoNormal"><b>/usr/pgsql-15/bin/raster2pgsql -d -s 4326 -t auto -R -F -Y -e /home/<username>/Downloads/2016-01-01_40m_k30.tif public.test_raster_table | psql -U <postgres-user> -d <db-name></b><o:p></o:p></p>
<p class="MsoNormal"><b> </b><o:p></o:p></p>
<p class="MsoNormal">After upgrading to PostGIS 3.2 I have been running into the following error when running my ingestion command:<o:p></o:p></p>
<p class="MsoNormal"> <o:p></o:p></p>
<p class="MsoNormal"><b>[user@host Downloads]$ /usr/pgsql-15/bin/raster2pgsql ....</b><o:p></o:p></p>
<p class="MsoNormal"><b>Processing 1/1: /home/demsa/Downloads/2016-01-01_40m_k30.tif</b><o:p></o:p></p>
<p class="MsoNormal"><b>INFO: Using computed tile size: 256x256</b><o:p></o:p></p>
<p class="MsoNormal"><b>DROP TABLE</b><o:p></o:p></p>
<p class="MsoNormal"><b>CREATE TABLE</b><o:p></o:p></p>
<p class="MsoNormal"><b>COPY 50</b><o:p></o:p></p>
<p class="MsoNormal"><b>COPY 50</b><o:p></o:p></p>
<p class="MsoNormal"><b>COPY 50</b><o:p></o:p></p>
<p class="MsoNormal"><b>COPY 50</b><o:p></o:p></p>
<p class="MsoNormal"><b>COPY 50</b><o:p></o:p></p>
<p class="MsoNormal"><b>COPY 50</b><o:p></o:p></p>
<p class="MsoNormal"><b>COPY 50</b><o:p></o:p></p>
<p class="MsoNormal"><b>COPY 50</b><o:p></o:p></p>
<p class="MsoNormal"><b>COPY 50</b><o:p></o:p></p>
<p class="MsoNormal"><b>munmap_chunk(): invalid pointer</b><o:p></o:p></p>
<p class="MsoNormal"><b>ERROR: rt_band_from_wkb: Premature end of WKB on band offline path reading</b><o:p></o:p></p>
<p class="MsoNormal"><b>CONTEXT: COPY backfill_table_mean, line 42, column rast: "010000010043EEF8D9F5353A3F4075AD9570363ABF9A3CA74761E4334043AAD5064C5641C000000000000000000000000000..."</b><o:p></o:p></p>
<p class="MsoNormal"><span lang="EN-US"> </span><o:p></o:p></p>
<p class="MsoNormal">I have successfully ingested out-DB rasters to the same database in the past. In fact, the <i>2016-01-01_40m_k30.tif</i> in the above command is one of the files that I have successfully ingested into the same database in the past.<o:p></o:p></p>
<p class="MsoNormal"><span lang="EN-US"> </span><o:p></o:p></p>
<p class="MsoNormal"><b><u><span lang="EN-US">Attemps to resolve:</span></u></b><o:p></o:p></p>
<ol style="margin-top:0in" start="1" type="1">
<li class="MsoNormal" style="mso-list:l1 level1 lfo3">I have created a blank raster in QGIS (<i>test.tif</i>), which is quite small (6x4 pixels) and attempted to ingest this with the above command. The same error appears, which leads me to believe there is
something wrong with the install of PostGIS/postgis_raster package that I have.<o:p></o:p></li><li class="MsoNormal" style="mso-list:l1 level1 lfo3">I copied both rasters (<i>2016-01-01_40m_k30.tif</i> and <i>test.tif</i>) across to another linux server (server B) which is has PostGIS 3.3.4. Using this command: /usr/pgsql-14/bin/raster2pgsql -d -s 4326
-t auto -R -F -Y -e /home/<username>/Downloads/2016-01-01_40m_k30.tif public.test_raster_table | psql -p 5432 -U <postgres-user> -d <dbname> -h <server A IP> I was successfully able to ingest both rasters into the database on server A.<o:p></o:p></li></ol>
<ol style="margin-top:0in" start="2" type="1">
<ol style="margin-top:0in" start="1" type="1">
<li class="MsoNormal" style="mso-list:l1 level2 lfo3">This leads me to believe that there is something wrong with the PostGIS version that I am using and not with the rasters themselves.<o:p></o:p></li></ol>
</ol>
<ol style="margin-top:0in" start="3" type="1">
<li class="MsoNormal" style="mso-list:l1 level1 lfo3">Tried various combinations of the raster2pgsql flags<o:p></o:p></li></ol>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" style="border-collapse:collapse">
<tbody>
<tr>
<td width="312" valign="top" style="width:233.75pt;border:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt">
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:inherit;color:#0C0D0E">Removed </span><code><span style="font-size:10.0pt;font-family:"var\(--ff-mono\)";color:#0C0D0E;border:none windowtext 1.0pt;padding:0in">-t auto</span></code><o:p></o:p></p>
</td>
<td width="312" valign="top" style="width:233.75pt;border:solid windowtext 1.0pt;border-left:none;padding:0in 5.4pt 0in 5.4pt">
<p class="MsoNormal"><span lang="EN-US">free(): invalid pointer</span><o:p></o:p></p>
</td>
</tr>
<tr>
<td width="312" valign="top" style="width:233.75pt;border:solid windowtext 1.0pt;border-top:none;padding:0in 5.4pt 0in 5.4pt">
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:inherit;color:#0C0D0E">Removed </span><code><span style="font-size:10.0pt;font-family:"var\(--ff-mono\)";color:#0C0D0E;border:none windowtext 1.0pt;padding:0in">-e</span></code><o:p></o:p></p>
</td>
<td width="312" valign="top" style="width:233.75pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt">
<p class="MsoNormal">COPY 50<br>
COPY 50<br>
COPY 50<br>
free(): invalid pointer<br>
ERROR: rt_raster_from_hexwkb: Raster HEXWKB input must have an even number of characters<br>
CONTEXT: COPY backfill_table_mean, line 42, column rast: "010000010043EEF8D9F5353A3F4075AD9570363ABF9A3CA74761E4334043AAD5064C5641C00000..."<o:p></o:p></p>
</td>
</tr>
<tr>
<td width="312" valign="top" style="width:233.75pt;border:solid windowtext 1.0pt;border-top:none;padding:0in 5.4pt 0in 5.4pt">
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:inherit;color:#0C0D0E">Removed </span><code><span style="font-size:10.0pt;font-family:"var\(--ff-mono\)";color:#0C0D0E;border:none windowtext 1.0pt;padding:0in">-Y</span></code><o:p></o:p></p>
</td>
<td width="312" valign="top" style="width:233.75pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt">
<p class="MsoNormal"><span lang="EN-US">ERROR: unterminated quoted string at or near "'2016-01-01_40m_k30."</span><o:p></o:p></p>
<p class="MsoNormal"><span lang="EN-US">LINE 1: ...362D30312D30315F34306D5F6B33302E74696600'::raster,'2016-01-0...</span><o:p></o:p></p>
</td>
</tr>
<tr>
<td width="312" valign="top" style="width:233.75pt;border:solid windowtext 1.0pt;border-top:none;padding:0in 5.4pt 0in 5.4pt">
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:inherit;color:#0C0D0E">Removed </span><code><span style="font-size:10.0pt;font-family:"var\(--ff-mono\)";color:#0C0D0E;border:none windowtext 1.0pt;padding:0in">-R</span></code><o:p></o:p></p>
</td>
<td width="312" valign="top" style="width:233.75pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt">
<p class="MsoNormal">munmap_chunk(): invalid pointer<br>
ERROR: rt_band_from_wkb: Premature end of WKB on band data reading (rt_<a href="http://wkb.c:201/">wkb.c:201</a>)<br>
CONTEXT: COPY backfill_table_mean, line 49, column rast: "010000010043EEF8D9F5353A3F4075AD9570363ABF8835813D97FE3340FE80203F676341C000000000000000000000000000..."<o:p></o:p></p>
</td>
</tr>
</tbody>
</table>
<p class="MsoNormal"><span lang="EN-US"> </span><o:p></o:p></p>
<p class="MsoNormal"><b><u>The results of running gdalinfo (on separate windows PC) on both of the rasters I tried to ingest:</u></b><o:p></o:p></p>
<p class="MsoNormal"><b> </b><o:p></o:p></p>
<p class="MsoNormal"><b>> gdalinfo 2016-01-01_40m_k30.tif</b><o:p></o:p></p>
<p class="MsoNormal">Driver: GTiff/GeoTIFF<o:p></o:p></p>
<p class="MsoNormal">Warning 1: PROJ: proj_create_from_database: <a href="file:///C:/Program">
C:\Program</a> Files\PostgreSQL\14\share\contrib\postgis-3.3\proj\proj.db contains DATABASE.LAYOUT.VERSION.MINOR = 0 whereas a number >= 2 is expected. It comes from another PROJ installation.<o:p></o:p></p>
<p class="MsoNormal">Files: 2016-01-01_40m_k30.tif<o:p></o:p></p>
<p class="MsoNormal">Size is 7265, 8338<o:p></o:p></p>
<p class="MsoNormal">Coordinate System is:<o:p></o:p></p>
<p class="MsoNormal">GEOGCRS["WGS 84",<o:p></o:p></p>
<p class="MsoNormal"> DATUM["World Geodetic System 1984",<o:p></o:p></p>
<p class="MsoNormal"> ELLIPSOID["WGS 84",6378137,298.257223563,<o:p></o:p></p>
<p class="MsoNormal"> LENGTHUNIT["metre",1,<o:p></o:p></p>
<p class="MsoNormal"> ID["EPSG",9001]]]],<o:p></o:p></p>
<p class="MsoNormal"> PRIMEM["Greenwich",0,<o:p></o:p></p>
<p class="MsoNormal"> ANGLEUNIT["degree",0.0174532925199433,<o:p></o:p></p>
<p class="MsoNormal"> ID["EPSG",9122]]],<o:p></o:p></p>
<p class="MsoNormal"> CS[ellipsoidal,2],<o:p></o:p></p>
<p class="MsoNormal"> AXIS["latitude",north,<o:p></o:p></p>
<p class="MsoNormal"> ORDER[1],<o:p></o:p></p>
<p class="MsoNormal"> ANGLEUNIT["degree",0.0174532925199433,<o:p></o:p></p>
<p class="MsoNormal"> ID["EPSG",9122]]],<o:p></o:p></p>
<p class="MsoNormal"> AXIS["longitude",east,<o:p></o:p></p>
<p class="MsoNormal"> ORDER[2],<o:p></o:p></p>
<p class="MsoNormal"> ANGLEUNIT["degree",0.0174532925199433,<o:p></o:p></p>
<p class="MsoNormal"> ID["EPSG",9122]]]]<o:p></o:p></p>
<p class="MsoNormal">Data axis to CRS axis mapping: 2,1<o:p></o:p></p>
<p class="MsoNormal">Origin = (17.844391979228011,-31.500006410136233)<o:p></o:p></p>
<p class="MsoNormal">Pixel Size = (0.000399944803551,-0.000399973379606)<o:p></o:p></p>
<p class="MsoNormal">Metadata:<o:p></o:p></p>
<p class="MsoNormal"> AREA_OR_POINT=Area<o:p></o:p></p>
<p class="MsoNormal"> TIFFTAG_SOFTWARE=GDAL 3.7.0e (3070046) (4.5.1;1700;3.0.0;2.0.7;;;;), PROJ 9.2.1 (EPSG.VERSION=v10.088;EPSG.DATE=2023-05-13;ESRI.VERSION=ArcGIS Pro 3.1;ESRI.DATE=2023-19-01;PROJ_DATA.VERSION=1.14;)<o:p></o:p></p>
<p class="MsoNormal">Image Structure Metadata:<o:p></o:p></p>
<p class="MsoNormal"> COMPRESSION=DEFLATE<o:p></o:p></p>
<p class="MsoNormal"> INTERLEAVE=BAND<o:p></o:p></p>
<p class="MsoNormal"> PREDICTOR=3<o:p></o:p></p>
<p class="MsoNormal">Corner Coordinates:<o:p></o:p></p>
<p class="MsoNormal">Upper Left ( 17.8443920, -31.5000064) ( 17d50'39.81"E, 31d30' 0.02"S)<o:p></o:p></p>
<p class="MsoNormal">Lower Left ( 17.8443920, -34.8349844) ( 17d50'39.81"E, 34d50' 5.94"S)<o:p></o:p></p>
<p class="MsoNormal">Upper Right ( 20.7499910, -31.5000064) ( 20d44'59.97"E, 31d30' 0.02"S)<o:p></o:p></p>
<p class="MsoNormal">Lower Right ( 20.7499910, -34.8349844) ( 20d44'59.97"E, 34d50' 5.94"S)<o:p></o:p></p>
<p class="MsoNormal">Center ( 19.2971915, -33.1674954) ( 19d17'49.89"E, 33d10' 2.98"S)<o:p></o:p></p>
<p class="MsoNormal">Band 1 Block=256x256 Type=Float32, ColorInterp=Gray<o:p></o:p></p>
<p class="MsoNormal"> Min=19.340 Max=27.754<o:p></o:p></p>
<p class="MsoNormal"> Minimum=19.340, Maximum=27.754, Mean=24.930, StdDev=1.194<o:p></o:p></p>
<p class="MsoNormal"> NoData Value=-9999<o:p></o:p></p>
<p class="MsoNormal"> Metadata:<o:p></o:p></p>
<p class="MsoNormal"> STATISTICS_APPROXIMATE=YES<o:p></o:p></p>
<p class="MsoNormal"> STATISTICS_MAXIMUM=27.753507614136<o:p></o:p></p>
<p class="MsoNormal"> STATISTICS_MEAN=24.93024257498<o:p></o:p></p>
<p class="MsoNormal"> STATISTICS_MINIMUM=19.340391159058<o:p></o:p></p>
<p class="MsoNormal"> STATISTICS_STDDEV=1.1943478187917<o:p></o:p></p>
<p class="MsoNormal"> STATISTICS_VALID_PERCENT=73.14<o:p></o:p></p>
<p class="MsoNormal"><span lang="EN-US"> </span><o:p></o:p></p>
<p class="MsoNormal"><b>> gdalinfo test_grid.tif</b><o:p></o:p></p>
<p class="MsoNormal">Driver: GTiff/GeoTIFF<o:p></o:p></p>
<p class="MsoNormal">Warning 1: PROJ: proj_create_from_database: <a href="file:///C:/Program">
C:\Program</a> Files\PostgreSQL\14\share\contrib\postgis-3.3\proj\proj.db contains DATABASE.LAYOUT.VERSION.MINOR = 0 whereas a number >= 2 is expected. It comes from another PROJ installation.<o:p></o:p></p>
<p class="MsoNormal">Files: test_grid.tif<o:p></o:p></p>
<p class="MsoNormal">Size is 6, 4<o:p></o:p></p>
<p class="MsoNormal">Coordinate System is:<o:p></o:p></p>
<p class="MsoNormal">GEOGCRS["WGS 84",<o:p></o:p></p>
<p class="MsoNormal"> DATUM["World Geodetic System 1984",<o:p></o:p></p>
<p class="MsoNormal"> ELLIPSOID["WGS 84",6378137,298.257223563,<o:p></o:p></p>
<p class="MsoNormal"> LENGTHUNIT["metre",1,<o:p></o:p></p>
<p class="MsoNormal"> ID["EPSG",9001]]]],<o:p></o:p></p>
<p class="MsoNormal"> PRIMEM["Greenwich",0,<o:p></o:p></p>
<p class="MsoNormal"> ANGLEUNIT["degree",0.0174532925199433,<o:p></o:p></p>
<p class="MsoNormal"> ID["EPSG",9122]]],<o:p></o:p></p>
<p class="MsoNormal"> CS[ellipsoidal,2],<o:p></o:p></p>
<p class="MsoNormal"> AXIS["latitude",north,<o:p></o:p></p>
<p class="MsoNormal"> ORDER[1],<o:p></o:p></p>
<p class="MsoNormal"> ANGLEUNIT["degree",0.0174532925199433,<o:p></o:p></p>
<p class="MsoNormal"> ID["EPSG",9122]]],<o:p></o:p></p>
<p class="MsoNormal"> AXIS["longitude",east,<o:p></o:p></p>
<p class="MsoNormal"> ORDER[2],<o:p></o:p></p>
<p class="MsoNormal"> ANGLEUNIT["degree",0.0174532925199433,<o:p></o:p></p>
<p class="MsoNormal"> ID["EPSG",9122]]]]<o:p></o:p></p>
<p class="MsoNormal">Data axis to CRS axis mapping: 2,1<o:p></o:p></p>
<p class="MsoNormal">Origin = (16.639998682000002,-31.334238383999999)<o:p></o:p></p>
<p class="MsoNormal">Pixel Size = (1.000000000000000,-1.000000000000001)<o:p></o:p></p>
<p class="MsoNormal">Metadata:<o:p></o:p></p>
<p class="MsoNormal"> AREA_OR_POINT=Area<o:p></o:p></p>
<p class="MsoNormal">Image Structure Metadata:<o:p></o:p></p>
<p class="MsoNormal"> INTERLEAVE=BAND<o:p></o:p></p>
<p class="MsoNormal">Corner Coordinates:<o:p></o:p></p>
<p class="MsoNormal">Upper Left ( 16.6399987, -31.3342384) ( 16d38'24.00"E, 31d20' 3.26"S)<o:p></o:p></p>
<p class="MsoNormal">Lower Left ( 16.6399987, -35.3342384) ( 16d38'24.00"E, 35d20' 3.26"S)<o:p></o:p></p>
<p class="MsoNormal">Upper Right ( 22.6399987, -31.3342384) ( 22d38'24.00"E, 31d20' 3.26"S)<o:p></o:p></p>
<p class="MsoNormal">Lower Right ( 22.6399987, -35.3342384) ( 22d38'24.00"E, 35d20' 3.26"S)<o:p></o:p></p>
<p class="MsoNormal">Center ( 19.6399987, -33.3342384) ( 19d38'24.00"E, 33d20' 3.26"S)<o:p></o:p></p>
<p class="MsoNormal">Band 1 Block=6x4 Type=Float32, ColorInterp=Gray<o:p></o:p></p>
<p class="MsoNormal"> NoData Value=0<o:p></o:p></p>
<p class="MsoNormal"> <o:p></o:p></p>
<p class="MsoNormal"><b><u>The result of running sudo journalctl --no-pager | tail -n 30 immediately after raster2pgsql fails.</u></b><o:p></o:p></p>
<p class="MsoNormal">Feb 05 12:46:42 SUNGIS18 systemd[1]: Started Process Core Dump (PID 265814/UID 0).<o:p></o:p></p>
<p class="MsoNormal">Feb 05 12:46:42 SUNGIS18 systemd-coredump[265815]: Resource limits disable core dumping for process 265810 (raster2pgsql).<o:p></o:p></p>
<p class="MsoNormal">Feb 05 12:46:42 SUNGIS18 systemd-coredump[265815]: Process 265810 (raster2pgsql) of user 1000 dumped core.<o:p></o:p></p>
<p class="MsoNormal">Feb 05 12:46:42 SUNGIS18 systemd[1]: <a href="mailto:systemd-coredump@133-265814-0.service">
systemd-coredump@133-265814-0.service</a>: Deactivated successfully.<o:p></o:p></p>
<p class="MsoNormal">Feb 05 12:46:42 SUNGIS18 systemd[1]: Started Process Core Dump (PID 265819/UID 0).<o:p></o:p></p>
<p class="MsoNormal">Feb 05 12:46:42 SUNGIS18 systemd-coredump[265820]: Resource limits disable core dumping for process 265813 (postmaster).<o:p></o:p></p>
<p class="MsoNormal">Feb 05 12:46:42 SUNGIS18 systemd-coredump[265820]: Process 265813 (postmaster) of user 26 dumped core.<o:p></o:p></p>
<p class="MsoNormal">Feb 05 12:46:42 SUNGIS18 systemd[1]: <a href="mailto:systemd-coredump@134-265819-0.service">
systemd-coredump@134-265819-0.service</a>: Deactivated successfully.<o:p></o:p></p>
<p class="MsoNormal">Feb 05 12:46:44 SUNGIS18 sudo[265831]: demsa : TTY=pts/2 ; PWD=/home/demsa/Downloads ; USER=root ; COMMAND=/bin/journalctl --no-pager<o:p></o:p></p>
<p class="MsoNormal">Feb 05 12:46:44 SUNGIS18 sudo[265831]: pam_unix(<a href="sudo:session">sudo:session</a>): session opened for user root(uid=0) by demsa(uid=1000)<o:p></o:p></p>
<p class="MsoNormal"> <o:p></o:p></p>
<p class="MsoNormal">Any advice as to how I could investigate this further or resolve the issue would be much appreciated.<o:p></o:p></p>
<p class="MsoNormal"><span lang="EN-US"> </span><o:p></o:p></p>
<p class="MsoNormal"><span lang="EN-US">Many thanks</span><o:p></o:p></p>
<p class="MsoNormal"><span lang="EN-US">Sean Chater</span><o:p></o:p></p>
<p class="MsoNormal"> <o:p></o:p></p>
<p class="MsoNormal"><span style="font-size:8.5pt;font-family:"Verdana",sans-serif;color:#9B9F9E;mso-ligatures:none;mso-fareast-language:EN-ZA">The integrity and confidentiality of this email are governed by these terms.
<a href="https://www.sun.ac.za/emaildisclaimer/default.aspx">Disclaimer</a><br>
Die integriteit en vertroulikheid van hierdie e-pos word deur die volgende bepalings bereël.
<a href="https://www.sun.ac.za/emaildisclaimer/default.aspx">Vrywaringsklousule</a></span><span style="font-size:12.0pt;mso-ligatures:none;mso-fareast-language:EN-ZA">
<o:p></o:p></span></p>
</blockquote>
</div>
</div>
</div>
</body>
</html>