[osmosis-dev] Error reading API DB with --rd

[Shaun McDonald]

On 18 Sep 2012, at 13:25, Brett Henderson <brett at bretth.com> wrote:

> On 18 September 2012 22:15, Кирилл Бестужев <bestoujev at gmail.com> wrote:
> Thanks for the explanation. 
> 
> The wiki page I am talking about is http://wiki.openstreetmap.org/wiki/Rails_port/Database_schema
> 
> Okay.  It does appear to be out of date.  I believe the changes were made due to some limitations of Ruby on Rails.

As it states in the second paragraph on that page, the migrations are the official current status. That page won't be manually updated as the DB is updated as it's too much work, and the info is already stored in the code/git repo.

>  
> 
> And about the upgrade - can I upgrade the rails port db schema without loosing the data in the DB?
> 
> I believe so, because the main production database would have gone through the same upgrade steps.  I haven't done it myself though.
> 

If you have the rails codebase you should be able to run rake db:migrate and the upgrade to work through all the changes to the database. MySQL is not supported, only Postgres now.

Shaun

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/osmosis-dev/attachments/20120918/3b136fcb/attachment-0001.html>