Use osm2pgsql with the --slim flag and these tables will be created. Kind regards,
Milo van der Linden Michal Palenik wrote: > hello, > > after compiling osm2pgsql (it was the first time i compiled something > under linux, i thought it would be harder), ignoring a lot of error > messages (like in _int.sql from pgsql contrib a type is defined later > than used), and waiting, i have an almost working copy of gazetteer. > when i will have a working and reliabable order of import procedures > i'll let you know, so far it is only trial and fail. > > > last messages that occur and (probably) cause troubles are missing tables > planet_osm_ways/rels, i don't know how to create them. > > now i am able to search for streets and cities, however POIs are not findable > (in the www frontend). > > is there anything else i missed ? > > michal > > > On Wed, Jan 27, 2010 at 03:39:22PM +0200, Ciprian Talaba wrote: > >> 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
