Error when run migrations on Heroku, PostgreSQL with Rails 5

Question

I deploy Rails 5 with PostgreSQL to free app in Heroku. This is my configuration from database.yml:

production:
  adapter: postgresql
  username: root
  password:
  database: example

When I run heroku run rake db:migrate, I see this error:

rake aborted! PG::ConnectionBad: could not connect to server: No such file or directory Is the server running locally and accepting connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?

If I add this line to database.yml:

host: localhost

and run migration again, I see this error:

rake aborted! PG::ConnectionBad: could not connect to server: Connection refused Is the server running on host "localhost" (127.0.0.1) and accepting TCP/IP connections on port 5432?

How to fix it ?

Can you print the output of heroku config --app your_app_name command? — Radix
– Radix, Commented Jul 26, 2017 at 20:58
LANG: en_US.UTF-8 RACK_ENV: production RAILS_ENV: production RAILS_LOG_TO_STDOUT: enabled RAILS_SERVE_STATIC_FILES: enabled SECRET_KEY_BASE: yyyyyyyyyyyyyyyyyyyyyyy KEY HERE — gdfgdfg
– gdfgdfg, Commented Jul 26, 2017 at 21:01

Radix · Accepted Answer · 2017-07-26 21:04:00Z

21

It seems like database is not provided for your app, you need to add one:

heroku addons:create heroku-postgresql

You can verify the database was added to your application by running:

heroku config --app your_app_name

answered Jul 26, 2017 at 21:04

Radix

2,8171 gold badge23 silver badges45 bronze badges

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

Comments

taehyeong Kim · Accepted Answer · 2019-04-10 14:41:46Z

1

After delete old DB, you should execute this

heroku pg:promote HEROKU_POSTGRESQL_NEW_DATABASE

You can check your DB nickname by

heroku pg:info

answered Apr 10, 2019 at 14:41

taehyeong Kim

211 bronze badge

1 Comment

Laurenz Albe Over a year ago

Why should OP delete a database when the problem is to connect?

djmayank · Accepted Answer · 2017-07-26 21:08:12Z

0

Follow some steps in serial order,

$ heroku login
In Gemfile, add the pg gem to your Rails project. Change:

gem sqlite

to

gem 'sqlite3', group: :development
gem 'pg', '0.18.1', group: :production
In Gemfile, add the rails_12factor gem::

gem 'rails_12factor', group: :production
$ bundle install
Ensure config/database.yml is using the postgresql adapter. Change:

production:
<<: *default
database: db/production.sqlite3
to

production:
<<: *default
adapter: postgresql
database: db/production.sqlite3
$ git add .
$ git commit -m "Heroku config"
$ heroku create
$ git push heroku master
$ heroku run rake db:migrate
I hope it worked.

SO FOLLOW STEP 5 correctly.

edited Jul 26, 2017 at 21:08

answered Jul 26, 2017 at 21:02

djmayank

3922 silver badges20 bronze badges

1 Comment

gdfgdfg Over a year ago

rails_12factor is no needed for Rails 5. Check documentation: github.com/heroku/rails_12factor

Collectives™ on Stack Overflow

Error when run migrations on Heroku, PostgreSQL with Rails 5

3 Answers 3

Comments

1 Comment

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related