[postgis-users] raster2pgsql gives me segmentation fault

andy aborruso at gmail.com
Mon Dec 4 04:51:47 PST 2023


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/28afafb3/attachment.htm>


More information about the postgis-users mailing list