[Geocoding] Nominatim installation - Stuck at importing planet file
B1t4ng
b1t4ng at freemail.hu
Fri Nov 5 15:51:34 GMT 2010
Hi all! I'm new to this list and to geocoding as well. I'm trying to test geocoding with Nominatim on a Debian. I've followed these instructions: http://wiki.openstreetmap.org/wiki/Nominatim/InstallationI've installed PostgreSQL 8.3 with the corresponding utilities. Now when I'm trying to import an extract of the planet.osm with osm2pgsql, I get this error:select update_place(place_id::integer) from placex where indexed=false and class='place' and type='houses' failed: ERROR: relation "placex" does not exist I've tryed with multiple extracts, but the same error occured every time. Am I missing something? Do you have any idea about the cause of this? Here is the whole output: twain at fuge:~$ osm2pgsql -lsc -O gazetteer -C 512 -d gazetteer hungary.osm.bz2osm2pgsql SVN version 0.69-
Using projection SRS 4326 (Latlong)NOTICE: type "stringlanguagetype" does not exist, skippingNOTICE: type "keyvaluetype" does not exist, skippingNOTICE: function get_connected_ways(pg_catalog.int4[]) does not exist, skippingMid: pgsql, scale=10000000, cache=512MB, maxblocks=65537*8192Setting up table: planet_osm_nodesNOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "planet_osm_nodes_pkey" for table "planet_osm_nodes"Setting up table: planet_osm_waysNOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "planet_osm_ways_pkey" for table "planet_osm_ways"Setting up table: planet_osm_relsNOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "planet_osm_rels_pkey" for table "planet_osm_rels"
Reading in file: hungary.osm.bz2Processing: Node(1927k) Way(236k) Relation(4k)Node stats: total(1927122), max(919971808)Way stats: total(236188), max(78366035)Relation stats: total(4369), max(1185305)node cache: stored: 1927122(100.00%), storage efficiency: 4.78%, hit rate: 96.43%Stopping table: planet_osm_nodesStopping table: planet_osm_waysStopping table: planet_osm_relsBuilding index on table: planet_osm_waysStopped table: planet_osm_nodesBuilding index on table: planet_osm_relsStopped table: planet_osm_relsreStopped table: planet_osm_waysselect update_place(place_id::integer) from placex where indexed=false and class='place' and type='houses' failed: ERROR: relation "placex" does not exist
Error occurred, cleaning uptwain at fuge:~$ Thanks in advance! :)Gergő
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/geocoding/attachments/20101105/7d8caff6/attachment.html>
More information about the Geocoding
mailing list