<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Ah, i got the right hint.<br>
<br>
Yes, i've installed postgis but i used the wrong<br>
command with <u>-d gis</u> instead of -<b>d postgis</b>.<br>
<br>
Now the import-process is running - but i checked<br>
the installation folder of postgresql and saw that<br>
there's only 24GB left of space. Is that enough ?<br>
<br>
If not, how can i move the /data/ folder of my current<br>
postgresql-installation to another harddrive. is there<br>
a config-file where i can change the location/path ?<br>
<br>
regards,<br>
Andrew<br>
<br>
<br>
Hi,<br>
<br>
I guess that you are missing the PostGIS extensions for PostgreSQL.
Osm2pgsql is<br>
standalone and all is does is to import osm xml formated data into
PostgeSQL<br>
database (partly, it does not import everything). It does not need
anything<br>
from Mapnik, but is does need these additional PostGIS functions.
PostGIS is<br>
shipped with PostgreSQL and you can install it as an option, or install
it<br>
separately. <br>
I am running postgresql 8.2.6 with postgis-pg82-1.3.2. They play for
sure<br>
together with osm2pgsql. For some reason I seem to have downgraded from<br>
postgressql 8.3, but I do not remember why.<br>
<br>
<br>
<br>
<br>
Rahkonen Jukka schrieb:
<blockquote
cite="mid:CC197224AC75CE4DB23F739B16891B86E33F1A@tikka.haapa.mmm.fi"
type="cite">
<pre wrap="">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ä: <a class="moz-txt-link-abbreviated" href="mailto:contact@living-structures.de">contact@living-structures.de</a> [<a class="moz-txt-link-freetext" href="mailto:contact@living-structures.de">mailto:contact@living-structures.de</a>]
Lähetetty: pe 12.9.2008 19:23
Vastaanottaja: Rahkonen Jukka; <a class="moz-txt-link-abbreviated" href="mailto:talk@openstreetmap.org">talk@openstreetmap.org</a>
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:
</pre>
<blockquote type="cite">
<pre wrap="">contact <at> living-structures.de <contact <at> living-structures.de> writes:
</pre>
<blockquote type="cite">
<pre wrap="">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:
</pre>
</blockquote>
<pre wrap="">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
<a class="moz-txt-link-abbreviated" href="mailto:talk@openstreetmap.org">talk@openstreetmap.org</a>
<a class="moz-txt-link-freetext" href="http://lists.openstreetmap.org/listinfo/talk">http://lists.openstreetmap.org/listinfo/talk</a>
</pre>
</blockquote>
<pre wrap=""><!---->
</pre>
</blockquote>
<br>
</body>
</html>