Hi. I successfully used osmosis to load the cuurent map of germany into the postgres schema from Brett Henderson: http://gweb.bretth.com/apidb06-pgsql-latest.sql
Here is a short Howto: 1. I split the above skript into 2 parts at the COPY statements. 2. I ran the first part to create the schema without indexes and foreign keys. 3. I ran (the following is an example, adapt the parameters) bin/osmosis --read-xml-0.6 file=~/Desktop/download/germany.osm.bz2 --write-apidb-0.6 host=localhost database=osm1 user=osm password=**** populateCurrentTables=yes validateSchemaVersion=no 4. When osmosis started to copy into the current_* tables, things slowed down (nearly no disk writes, lots of reads). So I added the primary keys on nodes, node_tags, ways, way_nodes and way_tags and copying ran fast afterwards. 5. I ran the second part of the schema script creating the missing indexes and FKs. Done in about 6 hours. Sincerely, Joachim _______________________________________________ dev mailing list [email protected] http://lists.openstreetmap.org/listinfo/dev
