[postgis-users] Problem regarding tiff raster 's import into postgis
Pierre.Racine at sbf.ulaval.ca
Mon Nov 19 09:03:11 PST 2012
You can not store anything bigger than 1 GB in a PostgreSQL field.
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...
> -----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
> 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.
> View this message in context: http://postgis.17.n6.nabble.com/Problem-
> Sent from the PostGIS - User mailing list archive at Nabble.com.
> postgis-users mailing list
> postgis-users at lists.osgeo.org
More information about the postgis-users