[OSM-dev] Snapshot Server

[Paul Norman]

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.nickerson at gmail.com] 
Sent: Thursday, December 27, 2012 6:41 AM
To: Andy Allan; dev at 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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/dev/attachments/20121227/c9b4a1cd/attachment.html>