Home 2017 January PostgreSQL psql FATAL: error Peer authentication failed for user

PostgreSQL psql FATAL: error Peer authentication failed for user

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:

Anvesh Patel
PostgreSQL: How to Install PostgreSQL 9.6 on Ubuntu 16.04?PostgreSQL: Script to find Index Size and Index Usage Statistics
Comments: 1
  1. surendra
    June 1, 2019 at 10:34 am

    Nice

Anvesh Patel
Anvesh Patel

Database Engineer

January 16, 2017 PostgreSQL, , , , , , , , , , , , , , ,