[osmosis-dev] error caused by Caused by: org.postgresql.util.PSQLException: ERROR: column "active" of relation "users" does not exist
Michael musset
mickamusset at gmail.com
Wed Jun 23 10:10:52 BST 2010
Hi,
I've a france.osm from geofabrik
i'm trying to import it into my database with osmosis with this command :
./osmosis --read-xml file="/home/mickael/planet/france.osm" --write-apidb
populateCurrentTables=yes host="localhost" database="openstreetmap"
user="openstreetmap" validateSchemaVersion=no
the osmosis come from :
wget http://dev.openstreetmap.org/~bretth/osmosis-build/osmosis-bin-latest.tgz
tar xvfz osmosis-bin-latest.tgz
cd osmosis-0.35
chmod a+x bin/osmosis
bin/osmosis
my railsport config is :
test:
adapter: postgresql
database: osm_test
# username: osm_test
# password: osm_test
host: localhost
encoding: utf8
production:
adapter: postgresql
database: osm
# username: osm
# password: osm
host: localhost
encoding: utf8
development:
adapter: postgresql
database: openstreetmap
# username: openstreetmap
# password: openstreetmap
host: localhost
encoding: utf8
when i've created the database i've done :
createdb -E UTF8 -O openstreetmap openstreetmap
createdb -E UTF8 -O openstreetmap osm_test
createdb -E UTF8 -O openstreetmap osm
and
psql -d openstreetmap < /usr/share/postgresql/8.4/contrib/btree_gist.sql
+
rake db:migrate
env RAILS_ENV=production rake db:migrate
I don't understand what is wrong !
thx,
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/osmosis-dev/attachments/20100623/170db354/attachment.html>
More information about the osmosis-dev
mailing list