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”,…