<div>
Hi all!</div>
<div>
</div>
<div>
I'm new to this list and to geocoding as well. I'm trying to test geocoding with Nominatim on a Debian.</div>
<div>
</div>
<div>
I've followed these instructions: <a href="http://wiki.openstreetmap.org/wiki/Nominatim/Installation">http://wiki.openstreetmap.org/wiki/Nominatim/Installation</a></div>
<div>
I've installed PostgreSQL 8.3 with the corresponding utilities. </div>
<div>
</div>
<div>
Now when I'm trying to import an extract of the planet.osm with osm2pgsql, I get this error:</div>
<div>
<div id="cke_pastebin">
<span style="font-size:10px;"><span style="font-family:courier new,courier,monospace;">select update_place(place_id::integer) from placex where indexed=false and class='place' and type='houses' failed: ERROR: relation "placex" does not exist</span></span></div>
<div>
</div>
<div>
I've tryed with multiple extracts, but the same error occured every time.</div>
<div>
</div>
<div>
Am I missing something? Do you have any idea about the cause of this?</div>
<div>
</div>
<div>
Here is the whole output:</div>
<div>
</div>
<div>
<div id="cke_pastebin">
<span style="font-size:10px;"><span style="font-family:courier new,courier,monospace;">twain@fuge:~$ osm2pgsql -lsc -O gazetteer -C 512 -d gazetteer hungary.osm.bz2</span></span></div>
<div id="cke_pastebin">
<span style="font-size:10px;"><span style="font-family:courier new,courier,monospace;">osm2pgsql SVN version 0.69-</span></span></div>
<div id="cke_pastebin">
<span style="font-size:10px;"><span style="font-family:courier new,courier,monospace;"><br />
</span></span></div>
<div id="cke_pastebin">
<span style="font-size:10px;"><span style="font-family:courier new,courier,monospace;">Using projection SRS 4326 (Latlong)</span></span></div>
<div id="cke_pastebin">
<span style="font-size:10px;"><span style="font-family:courier new,courier,monospace;">NOTICE: type "stringlanguagetype" does not exist, skipping</span></span></div>
<div id="cke_pastebin">
<span style="font-size:10px;"><span style="font-family:courier new,courier,monospace;">NOTICE: type "keyvaluetype" does not exist, skipping</span></span></div>
<div id="cke_pastebin">
<span style="font-size:10px;"><span style="font-family:courier new,courier,monospace;">NOTICE: function get_connected_ways(pg_catalog.int4[]) does not exist, skipping</span></span></div>
<div id="cke_pastebin">
<span style="font-size:10px;"><span style="font-family:courier new,courier,monospace;">Mid: pgsql, scale=10000000, cache=512MB, maxblocks=65537*8192</span></span></div>
<div id="cke_pastebin">
<span style="font-size:10px;"><span style="font-family:courier new,courier,monospace;">Setting up table: planet_osm_nodes</span></span></div>
<div id="cke_pastebin">
<span style="font-size:10px;"><span style="font-family:courier new,courier,monospace;">NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "planet_osm_nodes_pkey" for table "planet_osm_nodes"</span></span></div>
<div id="cke_pastebin">
<span style="font-size:10px;"><span style="font-family:courier new,courier,monospace;">Setting up table: planet_osm_ways</span></span></div>
<div id="cke_pastebin">
<span style="font-size:10px;"><span style="font-family:courier new,courier,monospace;">NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "planet_osm_ways_pkey" for table "planet_osm_ways"</span></span></div>
<div id="cke_pastebin">
<span style="font-size:10px;"><span style="font-family:courier new,courier,monospace;">Setting up table: planet_osm_rels</span></span></div>
<div id="cke_pastebin">
<span style="font-size:10px;"><span style="font-family:courier new,courier,monospace;">NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "planet_osm_rels_pkey" for table "planet_osm_rels"</span></span></div>
<div id="cke_pastebin">
<span style="font-size:10px;"><span style="font-family:courier new,courier,monospace;"><br />
</span></span></div>
<div id="cke_pastebin">
<span style="font-size:10px;"><span style="font-family:courier new,courier,monospace;">Reading in file: hungary.osm.bz2</span></span></div>
<div id="cke_pastebin">
<span style="font-size:10px;"><span style="font-family:courier new,courier,monospace;">Processing: Node(1927k) Way(236k) Relation(4k)</span></span></div>
<div id="cke_pastebin">
<span style="font-size:10px;"><span style="font-family:courier new,courier,monospace;">Node stats: total(1927122), max(919971808)</span></span></div>
<div id="cke_pastebin">
<span style="font-size:10px;"><span style="font-family:courier new,courier,monospace;">Way stats: total(236188), max(78366035)</span></span></div>
<div id="cke_pastebin">
<span style="font-size:10px;"><span style="font-family:courier new,courier,monospace;">Relation stats: total(4369), max(1185305)</span></span></div>
<div id="cke_pastebin">
<span style="font-size:10px;"><span style="font-family:courier new,courier,monospace;">node cache: stored: 1927122(100.00%), storage efficiency: 4.78%, hit rate: 96.43%</span></span></div>
<div id="cke_pastebin">
<span style="font-size:10px;"><span style="font-family:courier new,courier,monospace;">Stopping table: planet_osm_nodes</span></span></div>
<div id="cke_pastebin">
<span style="font-size:10px;"><span style="font-family:courier new,courier,monospace;">Stopping table: planet_osm_ways</span></span></div>
<div id="cke_pastebin">
<span style="font-size:10px;"><span style="font-family:courier new,courier,monospace;">Stopping table: planet_osm_rels</span></span></div>
<div id="cke_pastebin">
<span style="font-size:10px;"><span style="font-family:courier new,courier,monospace;">Building index on table: planet_osm_ways</span></span></div>
<div id="cke_pastebin">
<span style="font-size:10px;"><span style="font-family:courier new,courier,monospace;">Stopped table: planet_osm_nodes</span></span></div>
<div id="cke_pastebin">
<span style="font-size:10px;"><span style="font-family:courier new,courier,monospace;">Building index on table: planet_osm_rels</span></span></div>
<div id="cke_pastebin">
<span style="font-size:10px;"><span style="font-family:courier new,courier,monospace;">Stopped table: planet_osm_relsre</span></span></div>
<div id="cke_pastebin">
<span style="font-size:10px;"><span style="font-family:courier new,courier,monospace;">Stopped table: planet_osm_ways</span></span></div>
<div id="cke_pastebin">
<span style="font-size:10px;"><span style="font-family:courier new,courier,monospace;">select update_place(place_id::integer) from placex where indexed=false and class='place' and type='houses' failed: ERROR: relation "placex" does not exist</span></span></div>
<div id="cke_pastebin">
<span style="font-size:10px;"><span style="font-family:courier new,courier,monospace;"><br />
</span></span></div>
<div id="cke_pastebin">
<span style="font-size:10px;"><span style="font-family:courier new,courier,monospace;">Error occurred, cleaning up</span></span></div>
<div id="cke_pastebin">
<span style="font-size:10px;"><span style="font-family:courier new,courier,monospace;">twain@fuge:~$ </span></span></div>
</div>
<div>
</div>
<div>
Thanks in advance! :)</div>
<div>
Gergõ</div>
</div>