title: Nominatim european map indexing/import
body: <p>I have installed nominatim on my local centOS 6.6 machine following the wiki.guide there <a href="http://wiki.openstreetmap.org/wiki/Nominatim/Installation" rel="nofollow">http://wiki.openstreetmap.org/wiki/Nominatim/Installation</a>
  I follow the instructions line to line and I manage to import a little map (monaco-latest.osm.pbf) and everything goes fine. Now I tried to import the european map (15.8 gb), i follow the same procedure, I launch the command</p>
  
  <pre><code> ./utils/setup.php --osm-file european.latest.osm.pbf --all --osm2pgsql-cache 2048 2&gt;&amp;1 | tee setup.log
  </code></pre>
  
  <p>5 days ago and if I launch the command <em>ps -aux | more</em> I see the following output for nominatim/postgres process:</p>
  
  <pre><code>500      25306  0.0  0.0 230024   528 ?        S    Oct14   0:00 /usr/bin/php -C
  q ./utils/setup.php --osm-file /srv/mappe/europe-latest.osm.pbf --all --osm2pgsq l-cache 2048
  postgres 25310  0.0  0.0 509284  2792 ?        Ss   Oct14   0:00 postgres: mapserver nominatim [local] idle
  500      25336  2.6 51.3 3908808 2015768 ?     R    Oct14 182:24 /srv/Nominatim-2.3.1/osm2pgsql/osm2pgsql -lsc -O gazetteer --hstore -C 2048 -P 5432 -d nominatim /srv/mappe/europe-latest.osm.pbf
  postgres 25338  0.7  3.6 352208 142580 ?       Ss   Oct14  49:17 postgres: mapserver nominatim [local] COPY
  postgres 25339 39.3  3.5 325964 141056 ?       Rs   Oct14 2726:28 postgres: mapserver nominatim [local] idle in transaction
  postgres 25340  0.2  3.5 326520 141116 ?       Ss   Oct14  16:17 postgres: mapserver nominatim [local] COPY
  postgres 25341  0.0  0.0 325808  3156 ?        Ss   Oct14   0:00 postgres: mapserver nominatim [local] COPY
  </code></pre>
  
  <p>If, I launch the command:</p>
  
  <pre><code>psql -d postgres -c "select * from pg_stat_activity where datname = 'nominatim'"
  </code></pre>
  
  <p>I see some log but, a thing that worry me a lot, if I write the follow code:</p>
  
  <pre><code>su - postgres
  \connect nominatim
  \dt
  </code></pre>
  
  <p>I see just 9 table...</p>
  
  <p>What I have to do?? The process is still running?? Is stucked??</p>
  
  <p>I'm trying to install the european map in a machine with centOS 6.7 and 250gb Disk space 4gb ram</p>
  
  <p>Please help me.
  Thanks a lot</p>
  
  <p>Hi Artur and thanks a lot for your response.
  Now, reading your post I'm pretty sure that the process is busy because the setup.log is the same since 4 days..
  An important question: can I set the osm2pgsql -cache up to 18000 even if my machine RAM is 4GB?? I have read that the cache should be half of machine RAM, than if I have 4gb RAM cache should be 2048. Is it correct??
  Than now I tried to install the map in another machine, with 500 gb HD and 16gb RAM (is a centos 6.6 virtual machine).
  When I launch the map import I redirect the standard output and error to two different file:
  In the setup.log I can see some create table and some insert (file is about 100 row) and at the bottom of the file I see IMPORT
  Than I read the error.log file and I see an output like this:</p>
  
  <pre><code>NOTICE:  table "place" does not exist, skipping
  NOTICE:  type "keyvalue" does not exist, skipping
  NOTICE:  type "wordscore" does not exist, skipping
  NOTICE:  type "stringlanguagetype" does not exist, skipping
  NOTICE:  type "keyvaluetype" does not exist, skipping
  NOTICE:  function get_connected_ways(pg_catalog.int4[]) 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=2048MB, maxblocks=262144*8192, allocation method=11 Mid: pgsql, scale=10000000 cache=2048
  Setting up table: planet_osm_nodes
  NOTICE:  table "planet_osm_nodes" does not exist, skipping
  Setting up table: planet_osm_ways
  NOTICE:  table "planet_osm_ways" does not exist, skipping
  Setting up table: planet_osm_rels
  NOTICE:  table "planet_osm_rels" does not exist, skipping
  Reading in file: /srv/mappe/europe-latest.osm.pbf
  Processing: Node(10k 10.0k/s) Way(0k 0.00k/s) Relation(0 0.00/s)
  Processing: Node(20k 20.0k/s) Way(0k 0.00k/s) Relation(0 0.00/s)
  ...
  </code></pre>
  
  <p>And so on.. is the third time that I try to install this damned map and is the third time that the process stop at:</p>
  
  <pre><code>Processing: Node(1561860k 141.1k/s) Way(6002k 0.04k/s) Relation(0 0.00/s)
  </code></pre>
  
  <p>Exactly at this point the process stopped, and two times I see an error similar to 'gazzetter error exectuing external command' and another time no error appear and the process just stopped.
  Why this scenario?? Why the process stopped exactly at that point?
  Please help I googling a lot but I don't find nothing.
  Thanks </p>