[OSM-talk] osm2pgsql.exe for win32 | Connection ok but function addgeometrycolum( does'nt exist
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 Jukka Rahkonen schrieb: contact living-structures.de living-structures.de> writes: My PostgreSQL-Server is running on localhost port 5432 and i've set up a database called 'postgis' but when i try to osm2pgsql -d:postgis planet.osm i get this error: fe_sendauth: no password supplied but the database is set to 'public' - so, why i get this password error ? regards, andrewcontact living-structures.de schrieb: You need to change PosGIS settings in pg_hba.conf so that database does not require password. It means setting "method" to "trust". This belongs to restrictions of osm2pgsql for Windows: you cannot give db host, no port, no username nor password but everything must be set up so that the defaults work. ___ talk mailing list talk@openstreetmap.org http://lists.openstreetmap.org/listinfo/talk ___ talk mailing list talk@openstreetmap.org http://lists.openstreetmap.org/listinfo/talk
Re: [OSM-talk] osm2pgsql.exe for win32 | Connection ok but function addgeometrycolum( does'nt exist
contact living-structures.de 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. ___ talk mailing list talk@openstreetmap.org http://lists.openstreetmap.org/listinfo/talk
Re: [OSM-talk] osm2pgsql.exe for win32 | Connection ok but function addgeometrycolum( does'nt exist
On Fri, 2008-09-12 at 18:23 +0200, [EMAIL PROTECTED] wrote: > 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 ? You need postGIS which is an extension to PostgreSQL providing geospatial features: http://postgis.refractions.net/ Some instructions are on the Wiki but are none currently for Windows (you like might to add some) http://wiki.openstreetmap.org/index.php/Mapnik/PostGIS Jon ___ talk mailing list talk@openstreetmap.org http://lists.openstreetmap.org/listinfo/talk
