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
