[OSM-talk] cannot create database for osmosis 0.39

[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

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