[OpenStreetMap] #4613: Installing fresh openstreetmap database fails

[OpenStreetMap]

#4613: Installing fresh openstreetmap database fails
----------------------+-------------------------
 Reporter:  yurivict  |      Owner:  rails-dev@…
     Type:  defect    |     Status:  new
 Priority:  minor     |  Milestone:
Component:  website   |    Version:
 Keywords:            |
----------------------+-------------------------
 Using PostgresSQL 9.2.1 on FreeBSD 9.1 amd64.

 Command `rake db:migrate` always fails when it is run first, see log
 below. Second run though succeeds.

 I am not an expert in PostgreSQL, but it seems strange that the second run
 succeeds when the first run fails. So is this an error or not an error?

 This needs to be looked at.

 Version is from Git @ Sun Oct 7 22:08:10 2012 +0000

 --- log ---
 <...skipped...>
 ==  AddMoreChangesetIndexes: migrating
 ========================================
 -- add_index("changesets", ["created_at"],
 {:name=>"changesets_created_at_idx"})
    -> 0.0116s
 -- add_index("changesets", ["closed_at"],
 {:name=>"changesets_closed_at_idx"})
    -> 0.0122s
 -- add_index("changesets", ["min_lat", "max_lat", "min_lon", "max_lon"],
 {:method=>"GIST", :name=>"changesets_bbox_idx"})
 rake aborted!
 An error has occurred, this and all later migrations canceled:

 PG::Error: ERROR:  data type integer has no default operator class for
 access method "gist"
 HINT:  You must specify an operator class for the index or define a
 default operator class for the data type.
 : CREATE  INDEX "changesets_bbox_idx" ON "changesets" USING GIST
 ("min_lat", "max_lat", "min_lon", "max_lon")

 Tasks: TOP => db:migrate
 (See full trace by running task with --trace)

-- 
Ticket URL: <https://trac.openstreetmap.org/ticket/4613>
OpenStreetMap <http://www.openstreetmap.org/>
OpenStreetMap is a free editable map of the whole world