[Geocoding] nominatim installation

[Sarah Hoffmann]

On Thu, Jun 05, 2014 at 01:59:41PM +0200, Alessandra Donnini wrote:
> rerun of 
> ./utils/specialphrases.php --wiki-import > specialphrases.sql
> psql -d nominatim -f specialphrases.sql
> seems not work and I receive this kind of error for each table:
> psql:specialphrases.sql:58387: ERROR:  relation "place_classtype_natural_islet" already exists
> psql:specialphrases.sql:58388: ERROR:  relation "idx_place_classtype_natural_islet_centroid" already exists
> psql:specialphrases.sql:58389: ERROR:  relation "idx_place_classtype_natural_islet_place_id" already exists
> GRANT

Just doing the grant would have been sufficient in that case but
it looks like this one did the right thing as well. So that part is ok.

> After rerun tables place_classtype_%, search_name and placex are empty.

This has nothing to do with the special phrases. It looks like your initial
import still didn't work properly. You'll have to drop the DB and start from
scratch. Make sure you log the output of the setup script and carefully
check for errors after it is done. The final output should be about
CREATE INDEX (a lot of them). Also, I recommend trying with a very small
file first (e.g. the Liechtenstein excerpt).

Sarah