[postgis-devel] raster2pgsql failed to insert out-db raster(x, y : 16242, 66479)

[Regina Obe]

No it is not possible.  Performance wise it would suck too to store large rasters per row because of the mem copy stuff involved for some operations.

 

https://gis.stackexchange.com/questions/31871/are-there-limitations-using-a-postgis-out-db-raster

 

Sadly this limitation has existed for some time, and mostly a limitation of the underlying PostgreSQL.

 

With changes in PostgreSQL 12 allowing pluggable storage, we could revisit this topic perhaps for PostGIS 3.1.  I think it's too late to consider for upcoming PostGIS 3.0

 

Thanks,

Regina

 

 

 

From: postgis-devel [mailto:postgis-devel-bounces at lists.osgeo.org] On Behalf Of Pradeep kumar
Sent: Tuesday, May 14, 2019 3:54 AM
To: postgis-devel at lists.osgeo.org
Subject: [postgis-devel] raster2pgsql failed to insert out-db raster(x, y : 16242, 66479)

 

Dear All,
 
            I am trying to insert a raster (X,Y: 16242, 66479, size on
disk:825.3 MB, not compressed) using raster2pgsql tool with "-R" option.
 
command:  raster2pgsql -R test_image.tif  test_image | psql -U user -d
database
 
Error:  rt_raster_new: Dimensions requested exceed the maximum (65535 x
65535) permitted for a raster
 
This works if I use the tile option "-t heightxwidth". But then multiple
rows for a single raster in the database table are created, which is not a
desirable result for me.
 
So, I would like to store a raster with height or width more than 65535 in
the PostGIS database table as a single row. Is this possible? If so, can
you please provide me how?
 
My Environment:
Postgres Version: PostgreSQL 10.4 on x86_64-pc-linux-gnu, compiled by gcc
(Alpine 6.4.0) 6.4.0, 64-bit

Postgis version: POSTGIS="2.5.0" [EXTENSION] PGSQL="100"
GEOS="3.7.0-CAPI-1.11.0 673b9939" PROJ="Rel. 5.0.1, April 1st, 2018"
GDAL="GDAL 2.3.2, released 2018/09/21" LIBXML="2.9.8" LIBJSON="0.13.1"
RASTER
 
I am looking forward for your reply.
 
Best Regards,
Pradeep Gulla  

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-devel/attachments/20190514/f21bfdae/attachment.html>