ActiveRecord::NoDatabaseError FATAL: database "db/development.postgresql" does not exist

Question

I'm building a small app and it was working locally. Then when I went to deploy it on Heroku, this error popped up in my terminal:

remote:        An error occurred while installing sqlite3 (1.3.11), and 

Bundler cannot
remote:        continue.
remote:        Make sure that `gem install sqlite3 -v '1.3.11'` succeeds before bundling.
remote:  !
remote:  !     Failed to install gems via Bundler.
remote:  !     
remote:  !     Detected sqlite3 gem which is not supported on Heroku.
remote:  !     https://devcenter.heroku.com/articles/sqlite3
remote:  !
remote: 
remote:  !     Push rejected, failed to compile Ruby app
remote: 
remote: Verifying deploy...
remote: 
remote: !   Push rejected to pockettheskimm.
remote: 
To https://git.heroku.com/pockettheskimm.git
 ! [remote rejected] master -> master (pre-receive hook declined)

I subsequently read the documentation on Heroku, which told me that I have to use Postgres in my app instead of sqlite3. So I updated my app, swapping out sqlite3 for Postgres:

default: &default
  adapter: postgresql
  pool: 5
  timeout: 5000

development:
  <<: *default
  database: db/development.postgresql

# Warning: The database defined as "test" will be erased and
# re-generated from your development database when you run "rake".
# Do not set this db to the same as development or production.
test:
  <<: *default
  database: db/test.postgresql

production:
  <<: *default
  database: db/production.postgresql

but now when I run the app locally, I get this error in my browser:

ActiveRecord::NoDatabaseError
FATAL: database "db/development.postgresql" does not exist

Extracted source (around line #661):
659
660
661
662
663
664

        rescue ::PG::Error => error
          if error.message.include?("does not exist")
            raise ActiveRecord::NoDatabaseError.new(error.message, error)
          else
            raise
          end

What can I do to fix this?

You should read documentation carefully devcenter.heroku.com/articles/sqlite3#running-rails-on-postgres db/development.postgresql syntax is not allowed by postgres — Roman Kiselenko
– Roman Kiselenko, Commented Dec 10, 2015 at 13:58
Have you ran rake db:create && rake db:migrate on development after you've change your database.yml config file? — eugen
– eugen, Commented Dec 10, 2015 at 14:00

Community · Accepted Answer · 2017-05-23 11:46:36Z

12

This was the answer that worked for me:

"Have you ran rake db:create && rake db:migrate on development after you've change your database.yml config file? "

credit to https://stackoverflow.com/users/163640/eugen

edited May 23, 2017 at 11:46

CommunityBot

11 silver badge

answered Sep 16, 2016 at 22:07

Mr. Rene

1,35512 silver badges17 bronze badges

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

Comments

ari · Accepted Answer · 2020-11-08 20:35:13Z

1

This works for me:

rails db:create
rails db:migrate

answered Nov 8, 2020 at 20:35

ari

9739 silver badges13 bronze badges

Comments

Prashant4224 · Accepted Answer · 2015-12-10 14:03:37Z

0

Find the gem that has sqlite3 as a dependency and remove it from your Gemfile.Once you’ve done this run bundle install and ensure that sqlite3 no longer exists in your Gemfile.lock

answered Dec 10, 2015 at 14:03

Prashant4224

1,6111 gold badge15 silver badges22 bronze badges

Comments

codesforkids · Accepted Answer · 2020-11-08 20:44:09Z

0

try not using anything in your gem file until everything has proccesed otherwise ActiveRecord will function differently

answered Nov 8, 2020 at 20:44

codesforkids

96 bronze badges

Comments

Paulo Cheque · Accepted Answer · 2019-02-27 17:05:07Z

-1

Some initialiser should be using the DB before it is created, so the db:create breaks.

To fix the error in the root cause, fix the initialisers and your lib settings.

ps: In my case, it was the FactoryBot.

answered Feb 27, 2019 at 17:05

Paulo Cheque

2,83623 silver badges23 bronze badges

Collectives™ on Stack Overflow

ActiveRecord::NoDatabaseError FATAL: database "db/development.postgresql" does not exist

5 Answers 5

Comments

Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related