-----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 <[email protected]> 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 >[email protected] >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----- _______________________________________________ dev mailing list [email protected] https://lists.openstreetmap.org/listinfo/dev
