[osmosis-dev] Simple schema creation with osmosis-0.38

[bigspoon]

Thanks Peter.

Here's the steps I did with hstore to get things working on Ubuntu 10.10. Of
course, once I did all this QGIS shows me that the data isn't able to be
read :(

$ sudo apt-get install postgresql-8.4-hstore-new

// add hstore support to database as postgres user
$ psql -d OSMOSIS_OSM -f /usr/share/postgresql/8.4/contrib/hstore.sql

// create the osmosis schema
$ psql -d OSMOSIS_OSM -U gcorradini -W -f
/usr/local/src/osmosis/osmosis-0.38/script/pgsql_simple_schema_0.6.sql

// load the data
$ bzcat /WORKSPACE/osmosis/working/imports/gaza.osm.bz2 | 
~/Downloads/osmosis-0.38/bin/osmosis --read-xml file=/dev/stdin
--write-pgsql database="OSMOSIS_OSM" user="gisuser" passwor    d="gisuser"
host="localhost"




--
View this message in context: http://gis.638310.n2.nabble.com/Simple-schema-creation-with-osmosis-0-38-tp6504881p6506187.html
Sent from the Osmosis Development mailing list archive at Nabble.com.