[osmosis-dev] Reading multiple OSM extracts to a database

[Rich d'Rich]

I wondered if anyone had suggestions for this:

I have a database into which NewZealand.osm has been read, and I tried
to import England.osm. This fails after 2 hours with:
"ERROR: could not create unique index "pk_users"".

I'm assuming this because the "users" table is being inserted to and
already has common entries. (I was hoping that all the nodes and ways
wouldn't overlap as the areas are distinct, though this too wouldn't
work across a land border).

Are there any solutions beyond the obvious one of having one database
per country/extract?

(Apologies if this topic has already been done to death - I couldn't
find any reference in the last few months).

Cheers,
Rich :-)