[postgis-users] shp2pgsql problem with very large .shp-files

Stefan Zweig stefanzweig1881 at web.de
Thu Aug 16 03:09:12 PDT 2007


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 <postgis-users at postgis.refractions.net>
> Gesendet: 16.08.07 00:09:22
> An: PostGIS Users Discussion <postgis-users at postgis.refractions.net>
> 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
> postgis-users at postgis.refractions.net
> 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




More information about the postgis-users mailing list