[Geocoding] Nominatim Install Problems

[Gavin Jackson]

Hi guys,

I think I've hit the same problem on SLES 11 (running Enterprise DB 
Postgresql 8.4).

This is the second time I have hit this error (I upgraded the ram from 
4gb to 8gb to see if it would help resolve the problem).

Are there any specific postgres settings I need to set, or additional debug
information that I can provide to help figure out why this is occurring?

I am using the latest osm2psql code out of subversion.

I am using a complete planet file (the whole world) - initial import took 
about three days (dual core Intel Core 2 Duo 2.66ghz with 4gb RAM).

geocoder:/usr/local/osm2pgsql/gazetteer # cat gazetteer-loaddata.sql |psql
gazetteer -U postgres
Password for user postgres: 
TRUNCATE TABLE
TRUNCATE TABLE
TRUNCATE TABLE
TRUNCATE TABLE
TRUNCATE TABLE
TRUNCATE TABLE
TRUNCATE TABLE
TRUNCATE TABLE
TRUNCATE TABLE
TRUNCATE TABLE
TRUNCATE TABLE
TRUNCATE TABLE
TRUNCATE TABLE
TRUNCATE TABLE
TRUNCATE TABLE
TRUNCATE TABLE
TRUNCATE TABLE
TRUNCATE TABLE
TRUNCATE TABLE
TRUNCATE TABLE
TRUNCATE TABLE
TRUNCATE TABLE
TRUNCATE TABLE
TRUNCATE TABLE
TRUNCATE TABLE
TRUNCATE TABLE
TRUNCATE TABLE
TRUNCATE TABLE
TRUNCATE TABLE
TRUNCATE TABLE
TRUNCATE TABLE
DROP SEQUENCE
CREATE SEQUENCE
DROP SEQUENCE
CREATE SEQUENCE
ERROR:  out of memory
DETAIL:  Failed on request of size 24.
CONTEXT:  PL/pgSQL function "geometry_sector" line 5 at assignment
SQL statement "INSERT INTO location_point_26 values ( $1 , $2 , $3 , $4 , $5 ,
$6 , $7 ,ST_Centroid( $8 ))"
PL/pgSQL function "add_location" line 25 at SQL statement
PL/pgSQL function "placex_insert" line 207 at assignment
ERROR:  out of memory
DETAIL:  Failed on request of size 16.
CONTEXT:  PL/pgSQL function "get_country_code" line 9 at FOR over SELECT rows
PL/pgSQL function "placex_insert" line 108 at assignment
ERROR:  out of memory
DETAIL:  Failed on request of size 32.
CONTEXT:  PL/pgSQL function "get_country_code" line 9 at FOR over SELECT rows
PL/pgSQL function "placex_insert" line 173 at assignment
 count 
-------
     0
(1 row)

geocoder:/usr/local/osm2pgsql/gazetteer #