[OSM-dev] Snapshot Server
Paul Norman
penorman at mac.com
Fri Dec 28 05:52:23 GMT 2012
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>
More information about the dev
mailing list