This article is half-done without your Comment! *** Please share your thoughts via Comment ***
Recently, I have installed PostgreSQL 9.6 in Ubuntu 16.4.
You can access the previous article and can find full detail installation steps.
I was testing execution for one of my shell scripts. I have tried to connect PostgreSQL database and got this error. ” psql FATAL: error Peer authentication failed for user ”
During at database call, I was supplying the username and password. I check pg_hba.conf file and replace peer with a password.
In pg_hba.conf, change this line from value peer to password:
|
1 2 3 4 5 |
local all all peer to: local all all password |
