<pre>It has been about three weeks of trying to install gazetteer on my server but i have run into so many problems.<br>My server has postgresql-8.4 installed and osm2pgsql 0.705.<br><br>Am following the instructions directly from <a href="http://wiki.openstreetmap.org/wiki/Nominatim/Installation">http://wiki.openstreetmap.org/wiki/Nominatim/Installation</a> by replacing 8.3 with 8.4.<br>
I have followed all the steps one by one while ensuring that no errors occur.<br><br>When i reach the step<br>./osm2pgsql -lsc -O gazetteer -C 2000 -d gazetteer planet.osm.bz2<br>I replace planet.osm.bz2 with a file for a small city copenhagen so that it does not take so long.<br>
<br>After completing this step, i get the following results.<br><br>Reading in file: /home/dssali/smallcopenhagen.osm<br>Processing: Node(49k) Way(4k) Relation(143) parse time: 3s<br><br>Node stats: total(49414), max(1299345493)<br>
Way stats: total(4899), max(114788727)<br>Relation stats: total(143), max(1600367)<br>node cache: stored: 49414(100.00%), storage efficiency: 1.89%, hit rate: 100.00%<br>Stopping table: planet_osm_ways<br>Stopping table: planet_osm_rels<br>
Stopping table: planet_osm_nodes<br>Building index on table: planet_osm_ways<br>Building index on table: planet_osm_rels<br>Stopped table: planet_osm_rels<br>Stopped table: planet_osm_nodes<br>Stopped table: planet_osm_ways<br>
Segmentation fault<br><br>It ends with a Segmentation fault and the postgresql log file has<br><br>2011-06-25 14:42:49 CEST LOG: unexpected EOF on client connection<br><br>When i do this step<br><br>cat import_country_name.sql | psql gazetteer<br>
<br>I get an error<br><br>ERROR: type "keyvalue[]" does not exist<br>ERROR: relation "country_name" does not exist<br><br>I read from a post on this forum that keyvalue[] is created by osm2pgsql. I have done this about 100 times now but this error still persists.<br>
<br>When i ignore that error is move on to this step<br><br>cat gazetteer-functions.sql | psql gazetteer<br><br>I get the following errors<br>ERROR: type keyvalue[] does not exist<br>ERROR: incompatible library "/usr/share/osm2pgsql/gazetteer/.libs/gazetteer.so": version mismatch<br>
DETAIL: Server is version 8.4, library is version 9.0.<br><br>If i ignore these errors, the application keeps on complaining about missing functions.<br><br>I have tried to search with google and have got like a thousand suggestions that have all not solved my problems.<br>
I have come to this forum as a last resort and i hope you guys will be kind enough to help<br></pre>