NOTICE: help.openstreetmap.org is no longer in use from 1st March 2024. Please use the OpenStreetMap Community Forum

Hi there!

I've installed openstreetmap's Rails Port to check it out and there's something related to the 3 databases it uses that I don't understand.

The INSTALL.md files indicates that this port uses 3 databases, one for development (openstreetmap), one for testing (osm_test) and one for production (osm), and the 3 databases should be created during the rake db:create step. This step successfully created the first two in my case (openstreetmap and osm_test) but the "osm" production database is not there. The rake run didn't gave any errors so I'd like to know if this is normal or there's something I'm missing.

Also, I'd like to know exactly what's the purpose of each database this port uses? I've looked here, the wiki and the web but it's not clear to me what's what because I've read many things, from slippy maps to mapnik rendered databases to database replicas.

If anyone could point me in the right direction or provide me with a link to understand better this setup I'd appreciate it very much.

Thanks in advance!

asked 09 May '14, 17:40

edmv's gravatar image

edmv
11113
accept rate: 0%


It's normal to find only the development and test databases created, since those are the ones you normally need when developing the software. In a production system you set the RAILS_ENV to production, and it'll create the only the production database.

This is a standard setup for Ruby on Rails apps, so there's little need for any documentation about it that's OpenStreetMap-specific. You'll find general information about Ruby on Rails and the database setup in guides and tutorials all over the web.

permanent link

answered 09 May '14, 18:55

Andy%20Allan's gravatar image

Andy Allan
12.5k23128153
accept rate: 28%

Oh, that makes sense... so it's basically the same database as the others (schema, tables, etc...) am I right?

Thanks!

(10 May '14, 04:24) edmv

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×165
×118
×111
×100

question asked: 09 May '14, 17:40

question was seen: 3,090 times

last updated: 10 May '14, 04:24

NOTICE: help.openstreetmap.org is no longer in use from 1st March 2024. Please use the OpenStreetMap Community Forum