hi uwe, there is large file support (ext3) on the unix machine the shp2pgsql is running. and as well i have tried opening the shapefile with another application (arcgis) as you suggested. it worked alright.
i would not be happy with splitting up the shapefile into pieces. that would be lots of non-automated work, because we have some of these very large shapefiles. any other ideas? > -----Ursprüngliche Nachricht----- > Von: PostGIS Users Discussion <[email protected]> > Gesendet: 15.08.07 10:23:20 > An: "PostGIS Users Discussion" <[email protected]> > Betreff: Re: [postgis-users] shp2pgsql problem with very large .shp-files > > Am 15.08.2007, 09:51 Uhr, schrieb Stefan Zweig <[EMAIL PROTECTED]>: > > > hi list, > > > > i have a problem with the shp2pgsql program: > > > > this command: > > /usr/local/pgsql/bin/shp2pgsql -s 4326 -c -I -D -k > > /var/gisapp/postgreexport/_G342.shp public._g342 > > > /var/gisapp/postgreexport/_g342.sql > > works alright, no problems at all > > > > whereas this command: > > /usr/local/pgsql/bin/shp2pgsql -s 4326 -c -I -D -k > > /var/gisapp/postgreexport/_G2681.shp public._g2681 > > > /var/gisapp/postgreexport/_g2681.sql > > causes shp2pgsql to answer: > > > > "/var/gisapp/postgreexport/_G2681.shp: shape (.shp) or index files > > (.shx) can not be opened." > > > > ls -la in /var/gisapp/postgreexport/ says the following: > > > > -rwxrwxrwx 1 root root 171848556 2007-08-14 18:38 _G2681.dbf > > -rwxrwxrwx 1 root root 143 2007-08-14 18:38 > > _G2681.prj > > -rwxrwxrwx 1 root root 4565523268 2007-08-14 18:38 _G2681.shp > > -rwxrwxrwx 1 root root 124980820 2007-08-14 18:38 _G2681.shx > > -rwxrwxrwx 1 root root 308 2007-08-15 09:35 _G342.dbf > > -rwxrwxrwx 1 root root 143 2007-08-15 09:35 _G342.prj > > -rwxrwxrwx 1 root root 716 2007-08-15 09:35 _G342.shp > > -rwxrwxrwx 1 root root 276 2007-08-15 09:35 _G342.shx > > > > > > so the only difference between shp-file _g2681 and shp-file _g342 is > > that _g2681 is an extremely big one. (and actually there is another > > difference: _G342.shp is a point shape, _g2681.shp is a line shape) > > > > any ideas? > > > > i appreciate any help, thanks in advance, > > > > stefan > > > > Maybe this is a Problem of the filesystem or large file support. Does the > shapefile work in other applications? maybe there is a border in the > indexnumber, so that it cann't be opened. > Maybe you can split your shape and import the pieces ;) > > bye uwe > > _____________________________________ > ingenieurbüro kauppert > > nebeniusstr. 34 > d-76137 karlsruhe > > fon +49 721 3548969-3 > fax +49 721 3548969-5 > > email [EMAIL PROTECTED] > web www.ib-kauppert.de > _____________________________________ > _______________________________________________ > postgis-users mailing list > [email protected] > http://postgis.refractions.net/mailman/listinfo/postgis-users > _____________________________________________________________________ Der WEB.DE SmartSurfer hilft bis zu 70% Ihrer Onlinekosten zu sparen! http://smartsurfer.web.de/?mc=100071&distributionid=000000000066 _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
