[OSM-dev] problem with planet dump?

[Dave Stubbs]

the total space for the postgis db with a full planet import is currently 4.6GB

I don't know what it requires for any import overhead though


On 16/11/2007, Joerg Ostertag (OSM Munich/Germany)
<openstreetmap at ostertag.name> wrote:
> On Mittwoch 14 November 2007, Jon Burgess wrote:
> > I tried importing the latest planet dump into the Mapnik osm2pgsql and
> > it reports a problem with the XML. I haven't yet worked out if it is the
> > dump which broke or the import:
> >
> > Reading in file: planet-071114.osm.gz
> > Processing: Node(91831k) Way(7091k) Relation(0k)Entity: line 609760706:
> > parser error : Extra content at the end of the document
> >   </way>
> >         ^
> > planet-071114.osm.gz : failed to parse
>
> I'm trying to import this planet dump and I'm getting out of space. But the
> partition with the mapnik-postgis-database has still 3.5GB space left is this
> not enough? Can anyone give me an estimate how much space is needed for the
> postgis database in the meantime?
>
> Reading in file: /home/osm/osm/planet/planet.osm.bz2
> Processing: Node(10430k) Way(0k) Relation(0k)
> Processing: Node(92613k) Way(8189k) Relation(2k)
> Writing rel(2k)
>
> Writing way(507k)
>
> Node stats: total(92613260), max(113470523)
> Way stats: total(8189429), max(12477510)
> Relation stats: total(2710), max(3051)
> ANALYZE planet_osm_line;
> CREATE TABLE tmp AS SELECT * FROM planet_osm_line ORDER BY way;
> DROP TABLE planet_osm_line;
> ALTER TABLE tmp RENAME TO planet_osm_line;
> CREATE INDEX way_index1 ON planet_osm_line USING GIST (way GIST_GEOMETRY_OPS);
> GRANT SELECT ON planet_osm_line TO PUBLIC;
> ANALYZE planet_osm_line;
>  failed: FEHLER:  konnte Relation 1663/548255/608739 nicht erweitern: No space
> left on device
> HINT:  Prüfen Sie den freien Festplattenplatz.
>
> _______________________________________________
> dev mailing list
> dev at openstreetmap.org
> http://lists.openstreetmap.org/cgi-bin/mailman/listinfo/dev
>