[OSM-dev] osm2pgsql: append-mode (error message)

Simon Poole simon at poole.ch
Wed Dec 31 16:28:46 UTC 2014


-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA512

You shoule merge the 3 files in advance and import once. IMHO the merge option simply retains existing data but does not actually "merge" it.

On 31. Dezember 2014 15:45:58 MEZ, Stefan Mohr <gis at nordie.de> wrote:
>Hi everyone,
>
>
>
>I am relatively new to using OSM data and osm2pgsql and have been doing
>some
>testing during the last few weeks. I am using the following command
>lines
>and I am pretty not sure, if I am doing it in the right way:
>
>
>
>osm2pgsql --verbose --create --slim --cache 4096 --prefix planet_osm
>--database osmtest --username gis --host localhost --hstore
>--extra-attributes --style /gis/maps/planet/style/default.style
>--number-processes 4 --bbox 7.85,51.50,11.32,55.06
>schleswig-holstein-latest.osm.pbf
>
>
>
>osm2pgsql --verbose --append --slim --cache 4096 --prefix planet_osm
>--database osmtest --username gis --host localhost --hstore
>--extra-attributes --style /gis/maps/planet/style/default.style
>--number-processes 4 --bbox 7.85,51.50,11.32,55.06
>hamburg-latest.osm.pbf
>
>
>
>osm2pgsql --verbose --append --slim --cache 4096 --prefix planet_osm
>--database osmtest --username gis --host localhost --hstore
>--extra-attributes --style /gis/maps/planet/style/default.style
>--number-processes 4 --bbox 7.85,51.50,11.32,55.06
>niedersachsen-latest.osm.pbf
>
>
>
>The result should be a "merging" of 3 osm data files, the first line is
>doing a good job , but during the second line there is an error:
>
>
>
>Reading in file: hamburg-latest.osm.pbf
>
>Processing: Node(2156k 113.5k/s) Way(405k 27.00k/s) Relation(0
>0.00/s)COPY_END for COPY planet_osm_ways FROM STDIN;
>
>failed: ERROR:  duplicate key value violates unique constraint
>"planet_osm_ways_pkey"
>
>DETAIL:  Key (id)=(3075476) already exists.
>
>CONTEXT:  COPY planet_osm_ways, line 193
>
>
>
>I would be glad if anyone could tell me, what I have missed and what I
>am
>doing wring here? Thanks a lot,
>
>Stefan
>
>
>
>------------------------------------------------------------------------
>
>_______________________________________________
>dev mailing list
>dev at openstreetmap.org
>https://lists.openstreetmap.org/listinfo/dev

- --
Written with a pen on a Galaxy Note 10. I
-----BEGIN PGP SIGNATURE-----
Version: APG v1.1.1

iQE6BAEBCgAkBQJUpCQ+HRxTaW1vbiBQb29sZSA8c2ltb25AcG9vbGUuY2g+AAoJ
EEchcRCS4oLq3D8IAKJ8NHic/BlEE95vcShHb5lhveqLt72VZVA3UmIvhWsPNp0U
nCtq6044Fo0yfwnPZ9P9BTmraB3PGQ3uKVoQeAMVbU96R9fczUVi+1G559/tB8nz
LgfaI3+yDMt4MVSpbpeRcyc4cx4oHuPwU/TGGv88X3SC6558PFHnNKP5RtutkdtU
ua7a3qlEYGYZuh+UhXS/ED4K8hGsbzs369aksxBuraAQzQbCvsCS54/+QZjcVxaf
uWqbLrdG4jmgm8zixlQuBj+S/Fnlk9W378cLhMRikr/0ilsTPC5/TS7nDch+iZa6
iFoA0Y+kZg7x/L8xjP7vpOXWPST7Bbi/LZjVYEw=
=RY05
-----END PGP SIGNATURE-----




More information about the dev mailing list