[Geocoding] Nominatim Install Problems

[Jason Surratt]

Brian,

Thanks for the speedy response!

> The tables shouldn't have different SRIDs everything should be 4326.

Looks like this was the result of two problems. 
 
 1. When I installed proj on CentOS I omitted the proj-nad and proj-epsg packages.
 2. Somewhere along the way of trying to get things to work I added a '-m' flag to osm2pgsql. This fixed the immediate proj errors, but obviously introduced other projection errors later on.

After fixing this I successfully imported the Vatican City and performed some searches. Yippee!

I've since tried importing Denmark several times with various postgres.conf settings including the settings specified here: http://wiki.openstreetmap.org/wiki/Mapnik/PostGIS

My server is a dual quad core with 16GB of RAM and 10GB of swap space and decent disks, yet the import of just Denmark (~60MB compressed) takes several hours and eventually crashes with the below message and all RAM and swap in use. The crash appears to occur on " insert into placex select * from place where osm_type = 'N';" in gazetteer-index.sql.

WARNING:  terminating connection because of crash of another server process
DETAIL:  The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.
HINT:  In a moment you should be able to reconnect to the database and repeat your command.
CONTEXT:  PL/pgSQL function "add_location" line 24 at IF
PL/pgSQL function "placex_insert" line 200 at assignment
server closed the connection unexpectedly
        This probably means the server terminated abnormally
        before or while processing the request.
connection to server was lost

Thanks again!

-jason