[Geocoding] Geocoding larger files

[Sarah Hoffmann]

Hi,

On Tue, Oct 30, 2012 at 10:43:28PM -0400, Charles Randall wrote:
> All,
> I have Nominatim compiled, working and importing small files well on a
> machine.
> I've started working on updating larger files, but run into the following
> error - anyone else run into it or know how to work around it?
> Any help or insights on how to make progress would be

[...]

> 0.00/s)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.

It looks like your postgresql process was killed. Check you system logs 
for any reasons why postgresql might have died. It might just be
coincidence (running apt-get upgrade tends to do that to you) and you 
simply have to restart the import. If it is repeatable then there is
a good chance that you have run out of memory. Try reducing the memory
for postgresql. Also try reducing the memory that osm2pgsql uses, you
can do taht with the parameter: --osm2pgsql-cache <memory in MB>
Also try increasing the swap space on your system.


Sarah