[postgis-devel] [PostGIS] #1531: [raster] raster2pgsql loader aborts

PostGIS trac at osgeo.org
Thu Feb 2 09:08:41 PST 2012


#1531: [raster] raster2pgsql loader aborts
------------------------+---------------------------------------------------
  Reporter:  andreasft  |       Owner:  dustymugs          
      Type:  defect     |      Status:  closed             
  Priority:  medium     |   Milestone:  PostGIS 2.0.0      
 Component:  raster     |     Version:  trunk              
Resolution:  wontfix    |    Keywords:  raster2pgsql loader
------------------------+---------------------------------------------------
Changes (by dustymugs):

  * status:  assigned => closed
  * resolution:  => wontfix


Comment:

 I just tested the access_50k.zip and when run using the following command
 causes an abort:

 {{{
 raster2pgsql -s 4326 -I acc_50k access > access.sql
 }}}

 The following command does work due to the addition of the tiling flag:

 {{{
 raster2pgsql -t 50x50 -s 4326 -I acc_50k access > access.sql
 }}}

 From the looks of the raster, it has 43200x21600 pixels of datatype Int32.
 The loader attempts to allocate ~3732480000 bytes for the band and fails.

 The loader uses PostGIS raster's C API for handling the conversion from
 GDAL to raster hex.  I could replace the use of the API with a stream
 processor but I don't know if it is worth the effort.  Everything in
 PostGIS raster is performed in memory with no disk access (for temp files)
 but it may need to be considered if users are trying to load '''large'''
 rasters without tiling.

 It is strongly encouraged to tile your rasters as it does increase the
 performance of any queries run against the rasters.

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/1531#comment:3>
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.


More information about the postgis-devel mailing list