This is a static archive of our old OpenStreetMap Help Site. Please post any new questions and answers at community.osm.org.

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:

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

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

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