[osmosis-dev] Database is empty after five days of importing

[Klemens]

I keep replying myself ;)
In the meantime I dropped the whole database and started with a clean
one. The import of austria.osm finished after about 100 minutes and
everything seems to be in the DB.
Probably the problems were due to an inconsistent state of the DB. I got
'Caused by: org.postgresql.util.PSQLException: ERROR: duplicate key
value violates unique constraint "nodes_pkey"'
while testing with the old DB. So at some time in the future when I want
to import Europe into a DB that contains Austria I will have to create a
delta .osm first using osmosis?


On 24.03.2010 10:34, Klemens Z wrote:
> I tried with an even smaller excerpt now (only 257 KB compressed) and
> it worked! There's actually data in the tables now.
> 
> # bzcat ~/install/osm-dumps/liechtenstein.osm.bz2 |
> ./osmosis-0.34/bin/osmosis --read-xml-0.6 file=- --write-apidb-0.6
> populateCurrentTables=yes host="localhost" database="..." user="..."
> password="..." validateSchemaVersion=no
> Mar 24, 2010 9:42:58 AM org.openstreetmap.osmosis.core.Osmosis run
> INFO: Osmosis Version 0.34
> Mar 24, 2010 9:42:58 AM org.openstreetmap.osmosis.core.Osmosis run
> INFO: Preparing pipeline.
> Mar 24, 2010 9:42:58 AM org.openstreetmap.osmosis.core.Osmosis run
> INFO: Launching pipeline execution.
> Mar 24, 2010 9:42:58 AM org.openstreetmap.osmosis.core.Osmosis run
> INFO: Pipeline executing, waiting for completion.
> Mar 24, 2010 9:58:32 AM org.openstreetmap.osmosis.core.Osmosis run
> INFO: Pipeline complete.
> Mar 24, 2010 9:58:32 AM org.openstreetmap.osmosis.core.Osmosis run
> INFO: Total execution time: 934099 milliseconds.
> 
> 
> 2010/3/24 Brett Henderson <brett at bretth.com>:
>> Have you tried it with a smaller dataset first to make sure your import
>> process works?  It's not much fun waiting for several days only to find that
>