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/contri…
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 // saper(a)saper.info >>
_______________________________________________
talk mailing list
talk(a)openstreetmap.org
http://lists.openstreetmap.org/listinfo/talk