[osmosis-dev] Updating database with partial data

[Nuno Miguel Lourenço]

Hi,

I'm updating a OpenStreetMaps based DB, but we are doing incremental steps to the DB data.
We are importing just a few countries and then proceed to continents and at the end the planet file.

We are already using the country data! NOTE: The countries are not neighbors!
We are importing some Europe countries from  http://download.geofabrik.de/europe.html getting the several .osm.pbf files for the ones we want!

We are coming across an issue...
We are getting a lot of
Detail: Key (id)=(xxxxx) is duplicated.; nested exception is org.postgresql.util.PSQLException: ERROR: could not create unique index "pk_relations"
We are getting this for the relations table, for the nodes, ways tables also!!!

Is there any way we can avoid this?
We tried to remove the duplicates on the osmosisUpdate function but it did not work due to this being called after all the pushes of data to the DB.

Is there any other way to do this with osmosis?
Merging the several .osm.pbf files to generate a unique one is not a solution.

Thank you in advance.
Best regards,
Nuno Lourenço
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/osmosis-dev/attachments/20131010/338672cf/attachment.html>