There is more information available on this wiki page: http://wiki.openstreetmap.org/wiki/Planet.osm/FAQ
Shaun On 21 Sep 2009, at 20:33, Marcin Cieslak wrote: > I tried to import planet-090916.osm.bz2 into the postgres database > using osmosis, using empty schema from: > > URL: > http://svn.openstreetmap.org/applications/utils/osmosis/trunk/script/contrib/apidb_0.6.sql > Revision: 17698 > > The dump process: > > time bzip2 -dc $HOME/import/planet-090916.osm.bz2 | \ > $HOME/osmosis/trunk/bin/osmosis \ > --read-xml file=-\ > --write-apidb-0.6 authFile=$HOME/import/planet-authfile.txt > > failed after taking 26 hours and 415GB of space with: > > org.openstreetmap.osmosis.core.OsmosisRuntimeException: Unable to > load current way nodes. > (...) > Caused by: org.postgresql.util.PSQLException: > ERROR: insert or update on table "current_way_nodes" violates > foreign key constraint "current_way_nodes_node_id_fkey" > Detail: Key (node_id)=(497587545) is not present in table > "current_nodes". > > My current_nodes contains now 434807934 rows and current_ways 12050. > The highest numbered node is 497541099 and way is 1999800. > > Is this inconsistency of the planet.osm file or am I doing something > wrong? > Is there any way to recover from this or should I restart the whole > process from > scratch? > > Which dump would you recommend? > > -- > << Marcin Cieslak // [email protected] >> > > > _______________________________________________ > talk mailing list > [email protected] > http://lists.openstreetmap.org/listinfo/talk _______________________________________________ Maps-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/maps-l
