1👍
✅
Look into your pga_hba.conf
file and search for this line:
# TYPE DATABASE USER ADDRESS METHOD
local all all peer
and change peer
for md5
:
# TYPE DATABASE USER ADDRESS METHOD
local all all md5
Source:stackexchange.com