[Geocoding] Gazetteer instalation

[Ciprian Talaba]

Hi Michal,

On Wed, Jan 27, 2010 at 3:30 PM, Michal Palenik
<michal.palenik at freemap.sk>wrote:

> hello, i have problems installing/configuring Gazetteer on debian
> testing.
>
> i have osm2pgsql binary from packages, Gazetteer from todays svn
> database creation is ok, osm2pgsql is also ok (after correcting
> duplicate nodes)
>
> i have problems with step:
> cat gazetteer-functions.sql | psql -q gazetteer
>
> ERROR:  typy keyvalue[] does not exist
>
> should it be created by ?
>
>  CREATE TYPE keyvalue AS (
>  key TEXT,
>    value TEXT
>      );
>
>
> (i could not find it anywhere, neither in
> contrib nor in gazetteer)
>
>
> other missing types are:
> wordscore
> place_boundingbox
>
> also in gazetteer-index.sql
> place and placex have different structure, which causes
> insert into placex select * from place where osm_type = 'N';
> to fail
>
>
> michal
>
> ps:
> postgresql-contrib-8.3 needs to be installed
>
> pg_config is sometimes faulty, so i had to change the makefile to
> PGXS := $(shell /usr/lib/postgresql/8.3/bin/pg_config --pgxs)
>
> notes on role 'twain' are in some sql scripts
>
>
>
> --
> michal palenik
> www.freemap.sk
> http://wiki.freemap.sk
>
>
>
I had the most of these problems when I first tried Nominatim. The
solution(s) is to get the latest osm2pgsql from svn (
http://svn.openstreetmap.org/applications/utils/export/osm2pgsql/) and built
it from source. osm2pgsql is the one that creates the keyvalue type when
importing data using  gazetteer option.

The other missing types will be created at the second run of
gazetter-functions.sql file.

--Ciprian
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/geocoding/attachments/20100127/0ab2bb27/attachment.html>