[OSM-dev] Snapshot Server

[Rob Nickerson]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/dev/attachments/20121227/bd4fbe3e/attachment.html>