[postgis-users] Error in import of planet_osm

Torsten Mohr tmohr at s.netic.de
Tue Nov 1 11:08:48 PDT 2011


Hello,

i finally managed to import the latest planet_osm file to PostGIS, but i'm not 
sure if it really worked that well:

At the end of the import i got:
Going over pending relations

Pending relations took 3s at a rate of 0.00/s
node cache: stored: 104835304(8.44%), storage efficiency: 99.98%, hit rate: 
8.19%
Stopping table: planet_osm_ways
Stopping table: planet_osm_rels
Stopping table: planet_osm_nodes
Committing transaction for planet_osm_roads
Committing transaction for planet_osm_line
Committing transaction for planet_osm_polygon
Sorting data and creating indexes for planet_osm_line
Sorting data and creating indexes for planet_osm_roads
Sorting data and creating indexes for planet_osm_polygon
Committing transaction for planet_osm_point
Building index on table: planet_osm_rels (fastupdate=off)
Stopped table: planet_osm_nodes
Sorting data and creating indexes for planet_osm_point
Building index on table: planet_osm_ways (fastupdate=off)
Stopped table: planet_osm_rels
Indexes on  planet_osm_roads created  in 4315s
Completed planet_osm_roads
Indexes on  planet_osm_point created  in 4959s
Completed planet_osm_point
CREATE INDEX planet_osm_ways_nodes ON planet_osm_ways USING gin (nodes)  WITH 
(FASTUPDATE=OFF);
 failed: FEHLER:  konnte Datei »base/16384/392929.15« nicht erweitern: es 
wurden nur 4096 von 8192 Bytes bei Block 2072335 geschrieben
HINT:  Prüfen Sie den freien Festplattenplatz.
==> Translation: verify the free disk space.  I did, on /mnt where postgis is 
running, there are 71 Gb free.

Error occurred, cleaning up

But i can fetch data from the data base and create maps using mapnik.

Is there any step i need to redo manually?  Or that i should redo to improve 
performance?

I got PostGIS running on an SSD of 256 Gb, is that not sufficient for an 
import?


Thanks for any hints,
Torsten.



More information about the postgis-users mailing list