[postgis-tickets] [PostGIS] #2721: shp2pgsql fails with 4gig+ file

PostGIS trac at osgeo.org
Mon Apr 28 06:24:27 PDT 2014


#2721: shp2pgsql fails with 4gig+ file
---------------------+------------------------------------------------------
 Reporter:  treaves  |       Owner:  pramsey
     Type:  defect   |      Status:  new    
 Priority:  medium   |   Milestone:         
Component:  postgis  |     Version:  2.1.x  
 Keywords:           |  
---------------------+------------------------------------------------------
 I am attempting to import contour information into a PostGIS-enabled
 database.  I am trying to follow the information on this site:
 http://wiki.openstreetmap.org/wiki/Contours#Importing_the_SRTM3_data_.28deprecated.29
 and am using the script. The page states that srtm_generate_hdr.sh is no
 longer needed, but, I can find no instructions that do not use this
 script.

 I am importing data from ds.cr.usgs.gov/srtm/version2_1/SRTM1/Region_01 .
 The first couple of files in that directory import.  When the file
 N38W114.hgt.zip is processed, however, one of the intermediate files
 created by shp2pgsql starts growing in size, and when it reaches just over
 four gig, the max file size, it fails.  This particular data file isn't
 the largest that is imported.

 So I'm not sure how to troubleshoot were exactly the issue is; I suppose
 the issue could be with the data file, but, as several other files
 imported fine, I think the issue may be with shp2pgsql.

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/2721>
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-tickets mailing list