On Thu, Oct 11, 2012 at 02:52:32PM -0700, Charles Randall wrote: > I'll give that a shot - thank you. > Quick question - does the first ./utils/setup.php --all also need an xml > file only or is pbf ok for it (I assume the latter but thought I'd ask).
setup works fine with pbf. Sarah > On Thu, Oct 11, 2012 at 2:27 PM, Sarah Hoffmann <[email protected]> wrote: > > > On Thu, Oct 11, 2012 at 01:53:01PM -0700, Charles Randall wrote: > > > I've setup Nominatim on Centos 5 (64 bit) and went ahead and imported a > > > city streetmap file (using ./utils/setup.php --osm-file <file> --all). > > > Now I'm trying to install a second osm file. > > > > > > I run : > > > ./utils.update.php --import-file <filename> > > > > > > I get the following error: > > > > > > /home/palantir/Nominatim/ > > > osm2pgsql/osm2pgsql -klas -C 2000 -O > > > gazetteer -d nominatim /home/palantir/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 > > > PREPARE insert_node (int8, int4, int4, text[]) AS INSERT INTO > > > planet_osm_nodes VALUES ($1,$2,$3,$4); > > > PREPARE get_node (int8) AS SELECT lat,lon,tags FROM planet_osm_nodes > > > WHERE id = $1 LIMIT 1; > > > PREPARE delete_node (int8) AS DELETE FROM planet_osm_nodes WHERE id = $1; > > > failed: ERROR: relation "planet_osm_nodes" does not exist > > > LINE 1: ...rt_node (int8, int4, int4, text[]) AS INSERT INTO > > planet_osm... > > > ^ > > > > > > Error occurred, cleaning up > > > osm2pgsql exited with error level 1 > > > > > > > > > I checked postgres and I don't have a planet_osm_nodes table. I assumed > > > this would have been setup by the setup.php --all command but that didnt > > > work. I've run setup.php with the --create-tables option but no dice. > > > Any idea whats up and how I can work around this? > > > > It looks like you run ./utils/setup.php --import-data on this DB which > > unfortunally destroyed the data that you had already imported. So, you > > will have to start over again. > > > > Run ./utils/setup.php --all ... with the first file, then > > ./utils/update --import-file with any further osm files (these must > > be in xml format, not in pbf) and finally ./utils/update --index. > > > > Sarah > > _______________________________________________ Geocoding mailing list [email protected] http://lists.openstreetmap.org/listinfo/geocoding
