Unable to connect to PostgreSQL when using SQLite?

Question

The error I get is:

Could not load 'active_record/connection_adapters/postgresql_adapter'. Make sure that the adapter in config/database.yml is valid.

Here's my database.yml:

development:
  adapter: sqlite3
  database: db/development.sqlite3
  pool: 5
  timeout: 5000

production:
  adapter: postgresql
  user: test-app
  encoding: unicode

And my Gemfile:

# Use sqlite3 as the database for Active Record
gem 'sqlite3', :group => :development

group :production do
  # For Heroku
  gem 'rails_12factor'
  gem 'pg'
end

This identical setup works fine with another app, but for some reason refuses to here. Why is it even looking for PostgreSQL in development?

When running rails c or sending any web request.

Alfo
– Alfo

2013-11-09 15:33:05 +00:00
Commented Nov 9, 2013 at 15:33 — Alfo
– Alfo, Commented Nov 9, 2013 at 15:33

Alfo · Accepted Answer · 2013-11-09 16:22:07Z

1

I figured out what the problem was.

I am using the gem dotenv to load my Heroku ENV vars from the .env file into Rails, one of which is a Heroku Postgres URL in the variable ENV['DATABASE_URL'] that was messing with Rails in development.

I removed it and Rails started working properly again.

edited Nov 9, 2013 at 16:22

answered Nov 9, 2013 at 16:11

Alfo

4,81911 gold badges41 silver badges52 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Panagiotis · Accepted Answer · 2013-11-09 15:37:52Z

0

In the database.yml file, the adapter in production should be 'postgresql' not 'pg'.

answered Nov 9, 2013 at 15:37

Panagiotis

4214 silver badges14 bronze badges

2 Comments

Alfo Over a year ago

Changed it, didn't make a difference. It shouldn't even be looking at the production database details in development.

Panagiotis Over a year ago

Did you bundle install after editing your Gemfile?

Collectives™ on Stack Overflow

Unable to connect to PostgreSQL when using SQLite?

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related