Ah, i got the right hint.
Yes, i've installed postgis but i used the wrong
command with _-d gis_ instead of -*d postgis*.
Now the import-process is running - but i checked
the installation folder of postgresql and saw that
there's only 24GB left of space. Is that enough ?
If not, how can i move the /data/ folder of my current
postgresql-installation to another harddrive. is there
a config-file where i can change the location/path ?
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.
Rahkonen Jukka schrieb:
Addition to my last mail to posting list: you may have PosGIS installed, but
you have not created your database with PostGIS functions. I am no master in
this, I have just created my new PostGIS databases with wizard by using PostGIS
template.
Regards,
-Jukka-
-----Alkuperäinen viesti-----
Lähettäjä: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Lähetetty: pe 12.9.2008 19:23
Vastaanottaja: Rahkonen Jukka; talk@openstreetmap.org
Aihe: 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 <at> living-structures.de <contact <at> 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 <at> 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
