Getting authentication failed error with postgresql from command line

Question

When i try to login from command line like this

psql -h dbserver -U testuser test

then i get this error

psql: FATAL:  Ident authentication failed for user "testuser"

This is my

nano -w /var/lib/pgsql/data/pg_hba.conf

# TYPE  DATABASE    USER        CIDR-ADDRESS          METHOD

# "local" is for Unix domain socket connections only
local   all         all                               ident
# IPv4 local connections:
host    all         all         127.0.0.1/32          password
# IPv6 local connections:
host    all         all         ::1/128               ident
host    all     all     192.168.0.1/24  password

Change line local all all ident to local all all md5 and then follow Craig's answers, or run identd. — Robert H
– Robert H, Commented Nov 23, 2012 at 15:46

Craig Ringer · Accepted Answer · 2012-11-23 15:37:42Z

10

You can't specify a non-default user with -U in psql when using ident authentication. You won't be running psql as that user, so auth will fail.

You must either use sudo -u testuser psql test or change pg_hba.conf so that authentication (at least for testuser on the db test) uses md5 password authentication, and set a password for testuser with ALTER USER ... PASSWORD if they don't have one already.

answered Nov 23, 2012 at 15:37

Craig Ringer

329k83 gold badges742 silver badges820 bronze badges

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

Comments

KalenGi · Accepted Answer · 2014-04-16 14:31:35Z

1

I saw the following errors in /var/lib/pgsql/data/pg_log/postgresql-Wed.log:

LOG: provided username (DB_USER) and authenticated username (SHELL_USER) don't match FATAL: Ident authentication failed for user "DB_USER"

The solution in my case was to change all the authentication methods in /var/lib/pgsql/data/pg_hba.conf to md5

answered Apr 16, 2014 at 14:31

KalenGi

2,0694 gold badges27 silver badges43 bronze badges

Comments

Nandan Chaturvedi · Accepted Answer · 2018-05-10 18:16:52Z

With abovementioned, there can be two reasons for this issue - testuser not existing - wrong password or authentication failure for the user.

Here is what I did to resolve this in Windows:

Check via pgAdmin: Go to your programs and search for pgAdmin and run. Typically this will be running at http://127.0.0.1:51865/browser/

Check for the Login/Group Roles tab under Server "PostgreSQL". Check if the user is existing. You can also do this by logging to "postgres" user via command "psql -U postgres" and running command "\du"

If user testuser does not exist, create it.

Change the authentication methods in pg_hba.conf to md5. Alternatively,
change the password for the user with the command: ALTER USER ... PASSWORD.

Collectives™ on Stack Overflow

Getting authentication failed error with postgresql from command line

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related