[OSM-talk] osm2pgsql.exe for win32 | DB Connection ok -d postgis-import is running | is final DB-Size more than 20GB ?

[contact at living-structures.de]

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ä: contact at living-structures.de [mailto:contact at living-structures.de]
> Lähetetty: pe 12.9.2008 19:23
> Vastaanottaja: Rahkonen Jukka; talk at 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 at openstreetmap.org
>> http://lists.openstreetmap.org/listinfo/talk
>>   
>>     
>
>
>
>   

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/talk/attachments/20080912/9697543e/attachment.html>