HostOnNet Blog


PostgreSQL FATAL: Peer authentication failed for user “USER_NAME”

postgresql

On running a Ruby On Rails Application (anyone else use PostgreSQL ?), i get following error

FATAL:  Peer authentication failed for user "DB_NAME"

This is fixed by editing file pg_hba.conf

vi /etc/postgresql/9.5/main/pg_hba.conf

9.5 is version of postgresql. So it will be different on your server.

Find

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

Replace with

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

Restart PostgreSQL

root@s1:~# service postgresql stop
 * Stopping PostgreSQL 9.3 database server [ OK ] 
root@s1:~# service postgresql start
 * Starting PostgreSQL 9.3 database server [ OK ] 
root@s1:~#

Back to PostgreSQL


Posted in Windows