Readme.md for snapshot-server is not quite accurate. I've got an updated readme at https://github.com/pnorman/snapshot-server/blob/patch-3/README.md that covers enabling PostGIS and hstore but Andy hasn't had time to update upstream.
From: Rob Nickerson [mailto:rob.j.nicker...@gmail.com] Sent: Thursday, December 27, 2012 6:41 AM To: Andy Allan; dev@openstreetmap.org Subject: [OSM-dev] Snapshot Server 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 dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev