ActiveRecord::AdapterNotSpecified: 'postgresql' database is not configured

Question

I trying to figure out how fix the active record problem so I can push to heroku.

-----> Preparing app for Rails asset pipeline Running: rake assets:precompile rake aborted! ActiveRecord::AdapterNotSpecified: 'postgresql' database is not configured. Available: ["development", "adapter", "encoding", "database", "host", "pool", "username", "password", "production"]

  development:
  adapter: postgresql
  encoding: unicode
  database: sample_app_development
  host: localhost
  pool: 5
  username: sample_app
  password: 

test:
  adapter: postgresql
  encoding: unicode
  database: sample_app_test
  host: localhost
  pool: 5
  username: sample_app
  password: 


production:
  adapter: postgresql
  encoding: unicode
  database: sample_app_production
  host: localhost
  pool: 5
  username: sample_app
  password:

@Amjad nailed it - remove spaces on 1st line in front of " development:" — emgh3i
– emgh3i, Commented Sep 2, 2016 at 23:11

sovanlandy · Accepted Answer · 2014-12-18 14:59:48Z

5

There is a space before development in the db config. I believe To fix it, simply remove space from the first line and follow the indentation.

answered Dec 18, 2014 at 14:59

sovanlandy

1,7002 gold badges19 silver badges24 bronze badges

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

Comments

Mohamed Yakout · Accepted Answer · 2014-09-01 16:38:17Z

1

I think you need to write this command on terminal to create you database:

rake db:create

Then run rake db:migrate to run your migrations

answered Sep 1, 2014 at 16:38

Mohamed Yakout

3,0681 gold badge32 silver badges48 bronze badges

Comments

Amjad · Accepted Answer · 2015-06-27 04:09:21Z

1

Remove spaces on 1st line " development:"
Make sure of the database name e.g. "sample_app_development" or just "sample_app"
gem install pg
rake db:create
rake db:migrate

answered Jun 27, 2015 at 4:09

Amjad

4313 silver badges11 bronze badges

1 Comment

emgh3i Over a year ago

It was step #1 above that got me past my hour+ blockade -- didn't know leading spaces were an issue.

user3252359 · Accepted Answer · 2014-09-01 14:38:19Z

0

First install postgresql

gem install pg

Then create project using following command:

rails new myapp -d postgresql

answered Sep 1, 2014 at 14:38

user3252359

2 Comments

user3905353 Over a year ago

Thanks. I did this process first. My problem began once I did "git push heroku master"

user3252359 Over a year ago

I don't see any problem in your database.yml.

Collectives™ on Stack Overflow

ActiveRecord::AdapterNotSpecified: 'postgresql' database is not configured

4 Answers 4

Comments

Comments

1 Comment

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

1 Comment

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related