On the wrong mailing list http://lists.openstreetmap.org/pipermail/osmosis-dev/2013-August/001601.html
I asked and Sarah replied, with more points from me below: On 25 August 2013 23:15, Sarah Hoffmann <[email protected]> wrote: > Hi, > > are you sure that you got the right mailing list? > > On Sun, Aug 25, 2013 at 09:11:54PM +0100, Simon Nuttall wrote: >> I've hit this issue about 48 hours into processing a Europe - wide >> nominatim. Is there a way of proceeding? > > It seems to be just an update, simply run it again. --import-osmosis-all > will try to reapply the change automatically when restarted after you've > fixed the underlying problem. > >> 25-Aug-2013 19:45:34 org.openstreetmap.osmosis.core.Osmosis run >> INFO: Total execution time: 39209229 milliseconds. >> Completed for 2013-06-29T19:59:05Z in 1361.3 minutes >> /home/nominatim/Nominatim/osm2pgsql/osm2pgsql -klas -C 2000 -O >> gazetteer -d nominatim >> /home/nominatim/Nominatim/data/osmosischange.osc >> Using projection SRS 4326 (Latlong) >> Allocating memory for dense node cache >> Allocating dense node cache in one big chunk >> Allocating memory for sparse node cache >> Sharing dense sparse >> Node-cache: cache=2000MB, maxblocks=256001*8192, allocation method=11 >> Mid: pgsql, scale=10000000 cache=2000 >> Setting up table: planet_osm_nodes >> Setting up table: planet_osm_ways >> Setting up table: planet_osm_rels >> >> Reading in file: /home/nominatim/Nominatim/data/osmosischange.osc >> COPY_END for place failed: ERROR: column "addr_place" of relation >> "placex" does not exist >> LINE 2: street, addr_place, isin, postcode, country_code, extr... > > This looks like you have updated your Nominatim version without migrating > the database. There have been some changes in the DB schema recently. > The migration for the addr_place column is described here: > https://github.com/twain47/Nominatim/pull/54#issuecomment-17277092 > (needed after ddc46acd26) Ah right. My installation was in fact a re-installation, but I had deleted the nominatim database, so I thought that was enough. Where in the installation does the schema actually come from? Is it built by the code that comes from this section? cd Nominatim ./autogen.sh ./configure make If so then that explains why I hadn't got the latest schema, if not then I must have done something else wrong. I've updated our nominatim installation script at https://github.com/cyclestreets/nominatim-install to recomplie after a git update, so if the above is right that should have fixed the problem. > > The other significant DB schema changes was: > https://github.com/twain47/Nominatim/pull/45#issuecomment-16157763 > (needed after 23d303124e) > > Sarah _______________________________________________ Geocoding mailing list [email protected] http://lists.openstreetmap.org/listinfo/geocoding
