[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