Search code examples
ruby-on-rails-3sqliterakerails-postgresql

rake aborted! no such file to load -- sqlite3

I've set up a new rails3 app and my gemfile is below

source 'http://rubygems.org'
gem 'rails', '3.0.0'
gem 'nifty-generators'
gem 'pg'
gem 'authlogic'
gem 'jquery-rails'
gem "mocha", :group => :test

as seen from the Gemfile, I intend on using postgresql as the database and not the default sqllite3. however, when I tried doing rake db:create or rake db:migrate for the first time, it keeps giving me error rake aborted! no such file to load -- sqllite3

There was a file in db/development.sqllite which I deleted after I got this error...thinking that it will help. but it didn't.

Solution

  • Check your /config/database.yml file

    You probably have it still set to connect to a sqlite3 database (the default)