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

[Rich d'Rich]

Also, I should add that this is 0.36 and the command is:
osmosis --read-xml file="england.osm" --write-pgsql
database="Spatial_NZ" user="postgres" password="..."

On Mon, Nov 1, 2010 at 3:29 PM, Rich d'Rich <rich.d.rich at gmail.com> wrote:
> 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 :-)
>