[Geocoding] Geocoding larger files

[Charles Randall]

Thanks for all the recommendations Sarah. I'll follow up -

Regards,
Charles

On Wed, Oct 31, 2012 at 9:59 AM, Sarah Hoffmann <lonvia at denofr.de> wrote:

> 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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/geocoding/attachments/20121031/ea2d0e31/attachment.html>