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. _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
