Intel Core i7-920 Quad-Core, 8 GB DDR3 RAM, 2 x 750 GB SATA-II HDD (Software-RAID 1)
On 21.07.2010 12:58, Kirill Bestoujev wrote: > 23 days??? What kind of hardware do you use??? > > And yes, the database is unusable, the import did not finish. > > Kirill > > 2010/7/21 Klemens <toural...@gmail.com>: >> Hi, >> >> After 23 days of importing of planet.osm the task stopped with the >> following exception: >> >> 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)=(382854907) is not present in table "current_nodes". >> >> Here's the call I used: >> bzcat planet-100623.osm.bz2 | /root/install/osmosis-0.34/bin/osmosis >> --read-xml-0.6 file=- --write-apidb-0.6 populateCurrentTables=yes >> host="localhost" database="..." user="..." password="..." >> validateSchemaVersion=no >> >> The size of the DB was already 500 GB. I only need to a read-only DB do >> get nodes and ways using the rails_port. But probably this means that >> the DB is unusable now that the task didn't finish? >> >> Thanks! >> >> _______________________________________________ >> osmosis-dev mailing list >> osmosis-dev@openstreetmap.org >> http://lists.openstreetmap.org/listinfo/osmosis-dev >> > > _______________________________________________ > osmosis-dev mailing list > osmosis-dev@openstreetmap.org > http://lists.openstreetmap.org/listinfo/osmosis-dev > _______________________________________________ osmosis-dev mailing list osmosis-dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/osmosis-dev