PostgreSQL: Peer authentication failed for user

Ever since Oracle took the ownership of MySQL, I’ve been moving toward PostgreSQL, or other NoSQL database like MongoDB.

I’m not completely new to PostgreSQL, but the fact that I only have to touch it once in awhile, makes me feel PostgreSQL is so hard to use and missing the goold-oldie MySQL.

Anyway, this is the issue I had:

To fix it, we need to modify: pg_hba.conf. This file is located in /var/lib/pgsql/9.3/data/ directory on my system.

Change it to:

Ref: etting error: Peer authentication failed for user “postgres”,…