[Tile-serving] [openstreetmap/osm2pgsql] failed: ERROR: duplicate key value violates unique constraint "planet_osm_nodes_pkey" (#1272)

Jochen Topf notifications at github.com
Fri Sep 4 11:57:37 UTC 2020


I can't really follow your problem description, but it sounds like you are importing two extracts into the same database. This will fail if there is some overlap between the two extracts, i.e. if there is one node, way, or relation in both input files (in your case node 14455442 is already in the database). The only way to solve this is to merge all input files into one (using [`osmium merge`](https://docs.osmcode.org/osmium/latest/osmium-merge.html) for instance), start with an empty database, and import all data in one go.

Make sure that the input files you are merging are from the exact same point in time, otherwise the merge will not work correctly.

-- 
You are receiving this because you are subscribed to this thread.
Reply to this email directly or view it on GitHub:
https://github.com/openstreetmap/osm2pgsql/issues/1272#issuecomment-687098470
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20200904/33fe05e3/attachment.htm>


More information about the Tile-serving mailing list