Re: [talk-ch] Unique constraint violation during import with osm2pgsql

On Mon, Oct 03, 2016 at 11:41:33AM +0200, Rémi Bovard wrote:

Hi Sarah,

Thank you for your answer.

Here are the infos:

• Version: osm2pgsql SVN version af61cae663 (64bit id space)
• Command: osm2pgsql -s -H <host> -P <port> -U <user> -d <database> -S

default.style -p switzerland switzerland-latest.osm.pbf

I cannot find that specific version in the official git repos, so maybe this is some hacked versoin of osm2pgsql? The command line at least looks okay, I tried with pretty much the same command.

I've also checked the pbf and it doesn't contain any duplicates, so osm2pgsql is wrong here. Maybe it isn't properly deleting the nodes table before starting the import. Normally it should drop and recreate table.

In any case, I would recommend to try with a newer version of osm2pgsql. Either the 0.90.1 release or the newest source from github.

Kind regards

Sarah