[postgis-users] raster2pgsql gives me segmentation fault

[Regina Obe]

Which version of PostGIS and PostgreSQL are you running?

 

SELECT postgis_full_version(),  version();

 

Also is the data publicly accessible so we can test it out? 

If you can try it with https://github.com/postgis/docker-postgis  as Imre suggested, that would be great too.

 

I also assume you are not having issues with all tif files, and it’s this one specifically? 

 

From: postgis-users <postgis-users-bounces at lists.osgeo.org> On Behalf Of andy via postgis-users
Sent: Monday, December 4, 2023 7:52 AM
To: postgis-users at lists.osgeo.org
Cc: andy <aborruso at gmail.com>
Subject: [postgis-users] raster2pgsql gives me segmentation fault

 

Hi,

I'm using RELEASE: 3.3.2 GDAL_VERSION=36 (4975da8) in debian.

 

When I run this command

 

raster2pgsql -I -C -M -F -t auto -R ou_s6_01_01_stack.tif public.rasters_outdb

 

I have in the stdout the first part without errors, but after about 80 records I have error.

Below are some output example lines.

 

These are the tif metadata: https://gist.github.com/aborruso/caa16e5eb5d5b4756035f68bee191ed4

 

What can the problem be? How to solve it?

 

Thank you 

 

INSERT INTO "public"."rasters_outdb" ("rast","filename") VALUES ('0100000400392BA226FA7C743F392BA226FA7C74BFAE4A22FB20BF304098E315889EBA424000000000000000000000000000000000E61000000001E8008A00000000006F755F73365F30315F30315F737461636B2E746966008A00000000016F755F73365F30315F30315F737461636B2E746966008A00000000026F755F73365F30315F30315F737461636B2E746966008A00000000036F755F73365F30315F30315F737461636B2E74696600'::raster,'ou_s6_01_01_stack.tif');
INSERT INTO "public"."rasters_outdb" ("rast","filename") VALUES ('0100000400392BA226FA7C743F392BA226FA7C74BF626D8C9DF006324098E315889EBA424000000000000000000000000000000000E6100000C400E8008A00000000006F755F73365F30315F30315F737461636B2E746966008A00000000016F755F73365F30315F30315F737461636B2E746966008A00000000026F755F73365F30315F30315F737461636B2E746966008A00000000036F755F73365F30315F30315F737461636B2E74696600'::raster,'ou_s6_01_01_stack.tif');
CREATE INDEX ON "public"."rasters_outdb" USING gist (st_convexhull("rast"));
ANALYZE "public"."rasters_outdb";
SELECT AddRasterConstraints('public','rasters_outdb','rast',TRUE,TRUE,TRUE,TRUE,TRUE,TRUE,FALSE,TRUE,TRUE,TRUE,TRUE,TRUE);
END;
VACUUM ANALYZE "public"."rasters_outdb";
[1]    52988 segmentation fault  raster2pgsql -I -C -M -F -t auto -R ou_s6_01_01_stack.tif public.rasters_outd

 




 

-- 

___________________

 

Andrea Borruso
website: https://medium.com/tantotanto
38° 7' 48" N, 13° 21' 9" E, EPSG:4326
___________________

"cercare e saper riconoscere chi e cosa,
 in mezzo all’inferno, non è inferno, 
e farlo durare, e dargli spazio"

Italo Calvino

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20231204/1e4cb9a3/attachment.htm>