up vote 1 down vote favorite
share [fb]

For a Rails 3.1 app, I want to develop locally using SQLite and deploy to Heroku (which requires PostgreSQL).

I've set up my gemfile with

group :development, :test do
  gem 'sqlite3'
end

I can push to Heroku successfully but the app fails with

"Please install the postgresql adapter: `gem install activerecord-postgresql-adapter` (pg is not part of the bundle. Add it to Gemfile.)"

If I add the pg gem to my Gemfile and run bundle install, I get:

"ERROR: Failed to build gem native extension. (Gem::Installer::ExtensionBuildError)     /opt/local/bin/ruby extconf.rb checking for pg_config . . . not found"

because I don't have PostgreSQL installed locally.

I don't want to install PostgreSQL locally.

Is there a way to deploy to Heroku without installing PostgreSQL locally?

link|improve this question
69% accept rate
The best way is to develop on top of the same stack that you're deploying on. SQLite and PostgreSQL have different ideas about what valid SQL is and what things like varchar(100) mean. Developing on SQLite and deploying on PostgreSQL will cause ongoing grief. – mu is too short Dec 21 '11 at 18:25
Good advice in general but in this case I'm doing something very simple and it doesn't merit cluttering my development machine with an unused package. – Daniel Kehoe Dec 21 '11 at 18:30
feedback

2 Answers

up vote 4 down vote accepted 
bundle install --without production

should do the trick. See docs for further information.

link|improve this answer
feedback
up vote 1 down vote

This walks you through deploying a 3.1 app to heroku, since you already have your app built, skip to the deployment part of the video. Your issue is encountered @9.50 in the video

http://www.youtube.com/watch?v=p_3dIPgXgkg

link|improve this answer
feedback

Your Answer

 
or
required, but never shown

Not the answer you're looking for? Browse other questions tagged or ask your own question.