[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