Re: [OSM-talk] cannot create database for osmosis 0.39

2011-09-02 Thread Toby Murray 
On Fri, Sep 2, 2011 at 7:20 AM, Hadmut Danisch  wrote:
> But when using script/pgsnapshot_schema_0.6.sql instead, postgres rejects
> with error message
>
> psql:script/pgsnapshot_schema_0.6.sql:38: ERROR:  type "hstore" does not
> exist
> LINE 7: tags hstore
>  ^
>
> Obviously incomplete, definition of type "hstore" missing.
>
> So how would one create the database for osmosis?

Not sure about the pgsimple schema problem but for the pgsnapshot you
need to 1) have the postgres hstore-new module installed on the system
and 2) you need to have run the hstore-new.sql that comes with that
module against the database.

Here is a blog post about my experience setting up a pgsnapshot
database that might be useful:
http://ksmapper.blogspot.com/2011/04/parse-planet-into-pgsnapshot-database.html

Toby

___
talk mailing list
talk@openstreetmap.org
http://lists.openstreetmap.org/listinfo/talk

[OSM-talk] cannot create database for osmosis 0.39

2011-09-02 Thread Hadmut Danisch 
Hi,

I have a problem with using osmosis with postgresql:


When using script/pgsimple_schema_0.6.sql to generate the SQL schema,
osmosis terminates with error message

org.openstreetmap.osmosis.core.OsmosisRuntimeException: The database
schema version of 5 does not match the expected version of 6.


Obviously outdated.

But when using script/pgsnapshot_schema_0.6.sql instead, postgres
rejects with error message

psql:script/pgsnapshot_schema_0.6.sql:38: ERROR:  type "hstore" does
not exist
LINE 7: tags hstore
 ^

Obviously incomplete, definition of type "hstore" missing.


So how would one create the database for osmosis?


regards
Hadmut

___
talk mailing list
talk@openstreetmap.org
http://lists.openstreetmap.org/listinfo/talk