PG::ConnectionBad: FATAL: Ident authentication failed for user "rails_dev"

Question

When I run rails db:setup, I get this error message:

FATAL: Ident authentication failed for user "rails_dev"
Couldn't create database for {"adapter"=>"postgresql", "encoding"=>"unicode", "pool"=>5, "database"=>"myapp_test", "username"=>"rails_dev", "password"=>"aqwe123", "host"=>"localhost", "port"=>5432}
rails aborted!

PG::ConnectionBad: FATAL: Ident authentication failed for user "rails_dev"
/home/whitehat/.rvm/gems/ruby-2.4.0/gems/pg-0.21.0/lib/pg.rb:56:in 'initialize'
/home/whitehat/.rvm/gems/ruby-2.4.0/gems/pg-0.21.0/lib/pg.rb:56:in 'new'
/home/whitehat/.rvm/gems/ruby-2.4.0/gems/pg-0.21.0/lib/pg.rb:56:in 'connect

Can you paste your database.yml here?

Chetan Mehta
– Chetan Mehta

2017-08-26 09:55:15 +00:00
Commented Aug 26, 2017 at 9:55 — Chetan Mehta
– Chetan Mehta, Commented Aug 26, 2017 at 9:55

BryanH · Accepted Answer · 2020-01-21 17:28:10Z

1

After long search, I found the solution; the issue was in the PostgreSQL configuration file pg_hba.conf. I changed the ident method to MD5 and it worked.

local   all             all                                     MD5
host    all             all             127.0.0.1/32            MD5
host    all             all             ::1/128                 MD5

edited Jan 21, 2020 at 17:28

BryanH

6,1133 gold badges36 silver badges47 bronze badges

answered Aug 26, 2017 at 10:21

Ahmed Said

712 silver badges11 bronze badges

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

Collectives™ on Stack Overflow

PG::ConnectionBad: FATAL: Ident authentication failed for user "rails_dev"

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related