[postgis-users] Problem regarding tiff raster 's import into postgis

[Pierre Racine]

You can not store anything bigger than 1 GB in a PostgreSQL field.

http://www.postgresql.org/about/

This is true for raster as well. You have to tile your raster when you load it using the -t option so that it will be stored in multiple rows. This way the limit for one raster coverage becomes 32 TB...

Pierre

> -----Original Message-----
> From: postgis-users-bounces at lists.osgeo.org [mailto:postgis-users-
> bounces at lists.osgeo.org] On Behalf Of laurent
> Sent: Monday, November 19, 2012 11:57 AM
> To: postgis-users at postgis.refractions.net
> Subject: [postgis-users] Problem regarding tiff raster 's import into postgis
> 
> Hello,
> 
> I want import 39 raster tiff files in my postgis data base (tiff). I suceed
> in converting the 39 tiff files into one  sql file. The size of this sql
> file is 21,7 Go.
> 
> But i have an error message whenever i try to upload the sql into Postgis :
> " ERROR : invalid memory alloc request size 1073741824 / WARNING : Different
> geotransforms matrices found in the set of rasters being converted to
> Postgis Raster." I send by attachment the screen shot representing my prompt
> command (cf below).
> 
> In advance, thank you to throw light for me.
> 
> Kind regards.
> 
> <http://postgis.17.n6.nabble.com/file/n5001353/Error_message_Postgis_raster
> .jpg>
> 
> 
> 
> 
> --
> View this message in context: http://postgis.17.n6.nabble.com/Problem-
> regarding-tiff-raster-s-import-into-postgis-tp5001353.html
> Sent from the PostGIS - User mailing list archive at Nabble.com.
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users