ansaurus

Question

Heroku command: Heroku Rake db:migrate fails

Answer 1

A:

I'm not sure about the intricacies of the API, but the Heroku homepage shows them not using heroku db:migrate, but rather:

heroku rake db:migrate

Give that a go.

Matchu 2010-10-09 16:53:48

sorry, that was a typo, should include rake of course

Per-Olof Hermansson 2010-10-10 08:11:22

i.e a type here at StackOverflow, heroku rake db:migrate is what gave the error, but solution is to add gem "pg" in gemfile as the answer from Simon Carletti shows below.

Per-Olof Hermansson 2010-10-10 08:16:37

heroku completely ignores your database.yml and uses postgresql. So you can put in source control and use sqlite3 locally. You do not need the "pg" gem at all, heroku provides it, so keep your Gemfile clean and remove it if not used.

Ole Morten Amundsen 2010-10-17 14:58:06

@Ole: I'm not sure on that point. The Heroku docs [show including the pg gem](http://docs.heroku.com/bundler), and I'd really kinda prefer being explicit about that, anyway. Making it clear that I only want sqlite3 loaded in on development and that I only want pg on production is much better than depending on Heroku to make that happen magically.

Matchu 2010-10-17 16:42:44

I know for a fact that you don't need it in the Gemfile,I wanted to make the clear, but whether or not to include it in your Gemfile anyway, is up to you. I wouldn't :)

Ole Morten Amundsen 2010-10-17 20:13:43

Answer 2

+1 A:

Heroku doesn't support SQLite databases. You need to use PostgreSQL on production.

group :production, :staging do
  gem "pg"
end

group :development, :test do
  gem "sqlite3-ruby", "~> 1.3.0", :require => "sqlite3"
end

Simone Carletti 2010-10-09 18:40:51

WHere do I add these lines?

Per-Olof Hermansson 2010-10-10 07:39:36

sorry, I realized that I should add them in the gemfile... Now it works!! Thanks!

Per-Olof Hermansson 2010-10-10 08:00:16

If this answer solved the problem, you can accept it. ;)

Simone Carletti 2010-10-10 09:23:34

@Per-Olof Hermansson: on StackOverflow, when an answer solves your problem, it's important to click the green check mark next to it so that the person gets credit, and so that people know that this question has already been taken care of :) Thanks!

Matchu 2010-10-10 12:53:58

ansaurus

tags:

views:

answers:

Heroku command: Heroku Rake db:migrate fails

related questions