NOTICE: help.openstreetmap.org is no longer in use from 1st March 2024. Please use the OpenStreetMap Community Forum

Hello Everyone, I have successfully installed The Nominatim and the Postgresql db on my server. During the setup I imported the following dataset:

kenya-latest.osm.pbf

I now wanted to add the following dataset:

nigeria-latest.osm.bz2

I was given the impression I could do it with the following command:

./utils/update.php --import-file nigeria-latest.osm.bz2

but it is throwing the following error:

DB writer thread failed due to ERROR: Executing SQL ERROR: Error from osm2pgsql, 2

string(24) "Error from osm2pgsql, 2

I have tried googling but I have not found anything that could point out what was wrong. Please suggestions on how to fix the issue will be greatly appreciated.

asked 06 Feb '20, 13:49

imonike's gravatar image

imonike
963410
accept rate: 100%


update.php is for incremental data updates in https://wiki.openstreetmap.org/wiki/OsmChange format only. See https://wiki.openstreetmap.org/wiki/Planet.osm/diffs for an explanation. It's useful for keeping Kenya up-to-date, but you can't use it to add a new country/region.

For importing two countries you need to first merge the files kenya+nigeria, then import. In your case that means first deleting the database and starting again.

See https://help.openstreetmap.org/questions/48843/merging-two-or-more-geographical-areas-to-import-two-or-more-osm-files-in-nominatim and http://nominatim.org/release-docs/latest/admin/Faq/#can-i-import-multiple-countries-and-keep-them-up-to-date

permanent link

answered 06 Feb '20, 14:08

mtmail's gravatar image

mtmail
4.8k1574
accept rate: 27%

Thank you very much. I guess I start again. Is there a maximum to the number of datasets I can merge?

(06 Feb '20, 14:54) imonike

Many people install the whole world, so only hardware (size of your harddrive) is the limit.

(06 Feb '20, 14:57) mtmail

Thank you. You have been a great help.

(06 Feb '20, 15:08) imonike

Not show my address

permanent link

answered 15 Mar '20, 12:32

AR%20FURNITURE's gravatar image

AR FURNITURE
1
accept rate: 0%

@ar-furniture: please post a new question ("ask a question" on the top right hand corner of this page) describing exactly what you need help with. Your post here will be removed since you posted it as an answer to a totally unrelated question.

(15 Mar '20, 19:25) TZorn
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×689
×165
×44

question asked: 06 Feb '20, 13:49

question was seen: 1,998 times

last updated: 15 Mar '20, 19:25

NOTICE: help.openstreetmap.org is no longer in use from 1st March 2024. Please use the OpenStreetMap Community Forum