[Geocoding] URGENT Help Needed - Unable to import Ghana OSM file

[Sarah Hoffmann]

Hi,

On Tue, Dec 18, 2012 at 02:36:16PM +0530, Pradeep Rai wrote:
> I have set up Nominatim database for india and it is working well for
> reverse geo-coding.
> 
> Now i want to extend the reverse coding database for Ghana. For importing
> ghana.osm, i am using following command line :
> 
> sudo ./utils/setup.php --osm-file /home/../ghana.osm --import-data

This is not the right way to do it. Please check out this answer on help.osm.org:

https://help.openstreetmap.org/questions/15505/import-more-osm-files-in-to-nominatim

> output of command line is following:
> 
> root at pradeep:~/osm2pgsql/Nominatim# sudo ./utils/setup.php --osm-file
> /home/pradeep/ghana.osm --import-data
> Import
> Using projection SRS 4326 (Latlong)
> NOTICE:  drop cascades to function get_word_score(wordscore[],text[])
> NOTICE:  type "stringlanguagetype" does not exist, skipping
> NOTICE:  type "keyvaluetype" does not exist, skipping
> Allocating memory for dense node cache
> Allocating dense node cache in one big chunk
> Allocating memory for sparse node cache
> Sharing dense sparse
> Node-cache: cache=4583MB, maxblocks=586625*8192, allocation method=11
> Mid: pgsql, scale=10000000 cache=4583
> Setting up table: planet_osm_nodes
> NOTICE:  table "planet_osm_nodes" does not exist, skipping
> NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
> "planet_osm_nodes_pkey" for table "planet_osm_nodes"
> Setting up table: planet_osm_ways
> 
> I waited for 2-3 days to complete the import, but import process in not
> completed.

Unfortunately, you have removed all the data you previously imported for
India with this command, so you will have to start over from scratch.

Sarah