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

2014-12-31 Thread Stefan Mohr
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@openstreetmap.org
https://lists.openstreetmap.org/listinfo/dev


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

2014-12-31 Thread Simon Poole
-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 g...@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@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-


___
dev mailing list
dev@openstreetmap.org
https://lists.openstreetmap.org/listinfo/dev