Rails postgresql DB connection fails

Question

I'm very new to Ruby and postgres.

Below is my database.yml

development:
  adapter: postgresql
  database: test_database
  username: postgresql
  password: mypassword
  host: localhost
  encoding: utf8

The user exists and I'm, able to login using same credentials in phpPgadmin. But when I start rails server and go to home page of app, I get FATAL: Ident authentication failed for user "postgresql".

Edit: In case pghba.conf matters,

# TYPE  DATABASE          USER            ADDRESS                 METHOD

# "local" is for Unix domain socket connections only
#local    all             all                                     peer
local     all             postgres                                md5
local     all             postgresql                              md5

Could anyone please help ?

Can you log in to the command-line client with those credentials? — Jamison Dance
– Jamison Dance, Commented Feb 28, 2012 at 23:47

AMIC MING · Accepted Answer · 2012-03-02 22:20:09Z

2

open PostgreSQL client authentication configuration file

vi /var/lib/pgsql/data/pg_hba.conf

This file manage below stuffs

Which hosts are allowed to connect
How clients are authenticated
Which PostgreSQL user names they can use
Which databases they can access

By default Postgresql uses IDENT-based authentication. All you have to do is allow username and password based authentication for your network or webserver. IDENT will never allow you to login via -U and -W options. Append following to allow login via localhost only:

local   all all         trust
host    all 127.0.0.1/32    trust

Save and close the file. Restart Postgresql server:

service postgresql restart   OR
sudo /etc/init.d/postgresql restart

It should work

edited Mar 2, 2012 at 22:20

answered Feb 28, 2012 at 23:48

AMIC MING

6,3646 gold badges50 silver badges63 bronze badges

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

1 Comment

Kevin Triplett Over a year ago

Find pg_hba.conf in /etc/postgresql/X.X/main (replace X.X with your release number) if you're running Debian server.

Zeel · Accepted Answer · 2013-03-13 06:09:26Z

1

I can find my pg_hba.conf file in the path:

/etc/postgresql/8.4/main/pg_hba.conf

answered Mar 13, 2013 at 6:09

Zeel

2345 silver badges15 bronze badges

Comments

Cramps · Accepted Answer · 2013-07-29 19:25:01Z

1

For anyone who still can't find their pg_hba.conf file, I'm using PostgreSQL v9.2 and I found mine in:

/var/lib/pgsql/9.2/data/pg_hba.conf

answered Jul 29, 2013 at 19:25

Cramps

4646 silver badges16 bronze badges

1 Comment

Patrick Over a year ago

Same here, CentOS 6.6. Also, this file was owned by postgres, so I had become the postgres user to access it, ($ sudo su postgres).

Collectives™ on Stack Overflow

Rails postgresql DB connection fails

3 Answers 3

1 Comment

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related