hi mark, recompiling shp2pgsql with those flags seems to be a good idea. i am going to give that i try.
thanks, stefan > -----Ursprüngliche Nachricht----- > Von: PostGIS Users Discussion <[email protected]> > Gesendet: 16.08.07 00:09:22 > An: PostGIS Users Discussion <[email protected]> > Betreff: Re: [postgis-users] shp2pgsql problem with very large .shp-files > > On Wed, 2007-08-15 at 09:51 +0200, Stefan Zweig wrote: > > 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 > > > Hi Stefan, > > I'm not 100% sure, but I suspect that this is because your shapefile is > > 2GB and shp2pgsql doesn't have large file support :( > > If you are on a UNIX OS, you could try recompiling shp2pgsql with the > -D_LARGEFILE_SOURCE and -D_FILE_OFFSET_BITS=64 flags to see if that > allows you to work with the larger files. > > > ATB, > > Mark. > > -- > ILande - Open Source Consultancy > http://www.ilande.co.uk > > > _______________________________________________ > postgis-users mailing list > [email protected] > http://postgis.refractions.net/mailman/listinfo/postgis-users > _______________________________________________________________________ Jetzt neu! Schützen Sie Ihren PC mit McAfee und WEB.DE. 3 Monate kostenlos testen. http://www.pc-sicherheit.web.de/startseite/?mc=022220 _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
