[OSM-talk] osm2pgsql.exe for win32 | Connection ok but function addgeometrycolum( does'nt exist

[Jukka Rahkonen]

contact <at> living-structures.de <contact <at> living-structures.de> writes:

> 
> 
> ok, this works - but a new error appears:
> ... function addgeometrycollum(...) does'nt exist ...
> Do i have to import some mapnik-tables first ? - where i can find the
> import-file
> for this/these functions ?
> regards,
> andrew


Hi,

I guess that you are missing the PostGIS extensions for PostgreSQL. Osm2pgsql is
standalone and all is does is to import osm xml formated data into PostgeSQL
database (partly, it does not import everything).  It does not need anything
from Mapnik, but is does need these additional PostGIS functions.  PostGIS is
shipped with PostgreSQL and you can install it as an option, or install it
separately.  
I am running postgresql 8.2.6 with postgis-pg82-1.3.2.  They play for sure
together with osm2pgsql.  For some reason I seem to have downgraded from
postgressql 8.3, but I do not remember why.