update.php --import-file gives error

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.

nominatim postgresql ubuntu

asked 06 Feb '20, 13:49

imonike
96●3●4●10
accept rate: 100%

2 Answers:

active answers oldest answers newest answers popular answers

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
4.8k●15●74
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 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

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

learn more about Markdown

Question tags:

nominatim ×689
postgresql ×165
ubuntu ×44

question asked: 06 Feb '20, 13:49

question was seen: 2,271 times

last updated: 15 Mar '20, 19:25

./utils/update.php --import-file gives error

Follow this question

Related questions