[postgis-devel] [PostGIS] #1839: [raster] raster2pgsql is unable to handle TIFF subdatasets

[PostGIS]

#1839: [raster] raster2pgsql is unable to handle TIFF subdatasets
-----------------------------------------------------+----------------------
 Reporter:  turbothomas                              |       Owner:  dustymugs    
     Type:  defect                                   |      Status:  assigned     
 Priority:  medium                                   |   Milestone:  PostGIS 2.0.1
Component:  raster                                   |     Version:  2.0.x        
 Keywords:  raster2pgsql, TIFF, subdataset, history  |  
-----------------------------------------------------+----------------------

Comment(by dustymugs):

 Well, that was fun.  PostGIS Raster has a maximum permitted width/height
 size of 65535 x 65535.  Unfortunately, there was no obvious error message
 when you attempt to exceed that limit.  I was testing your Eiche*.tif file
 and hit it using...

 {{{
 raster2pgsql GTIFF_DIR:2:Eiche_1_1_2011_08_17_768_M2_3D_5mm.tif blabla
 }}}

 So, the lesson learned is that I need to add an explicit error message
 when someone hits this maximum and you really shouldn't call it the way I
 did above.  Please tile your raster to be at most 65535 x 65535.

 And before anyone asks why the maximum width and height is set to 65535 x
 65535, imagine the size of the following...

 65535 width * 65535 height * 8 bytes per pixel (64BF) = 34358689800 bytes
 (not counting overhead)

 That would be a very monstrous number considering the maximum size
 permitted in a single field of PostgreSQL is 1 GB
 (http://www.postgresql.org/about/) .

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/1839#comment:24>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.