Thanks for all the recommendations Sarah. I'll follow up - Regards, Charles
On Wed, Oct 31, 2012 at 9:59 AM, Sarah Hoffmann <[email protected]> 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 >
_______________________________________________ Geocoding mailing list [email protected] http://lists.openstreetmap.org/listinfo/geocoding
