Hi All, I am a complete newbie when it comes to databases and the like so please bear with me...
I am attempting to set up a snapshot server in order to feed UK Public Rights of Way data into Potlatch 2's merging tool. I am following Andy's guide at [1]. I am doing this in debian (raspberry pi version) as an initial proof of concept work. So far I have managed to get postgreSQL 9.1.7 set up and I have created a user "role": sudo -u postrgres psql # create role <username> login createdb; # \q (where lines 2 and 3 are run within postgresql). I have also put this username in config/database.yml and executed "rake db:create". However, when I run "rake db:migrate" I get the following error: PG::Error: ERROR relation “geometry_columns” does not exist LINE 1: SELECT * FROM geometry_columns WHERE f_table_name='schema_migrations' Any ideas? Regards, Rob [1] https://github.com/gravitystorm/snapshot-server
_______________________________________________ dev mailing list [email protected] http://lists.openstreetmap.org/listinfo/dev

