Hi Michal, On Wed, Jan 27, 2010 at 3:30 PM, Michal Palenik <[email protected]>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
_______________________________________________ Geocoding mailing list [email protected] http://lists.openstreetmap.org/listinfo/geocoding
