#############
# pg_hba.conf
#############
# Database administrative login by UNIX sockets
local all postgres ident sameuser
# TYPE DATABASE USER CIDR-ADDRESS METHOD
# "local" is for Unix domain socket connections only
local all all ident sameuser
local CUFTS2 all ident CUFTS
# IPv4 local connections:
host all all 127.0.0.1/32 md5
# IPv6 local connections:
host all all ::1/128 md5
###############
# pg_ident.conf
###############
# MAPNAME IDENT-USERNAME PG-USERNAME
CUFTS dan CUFTS
CUFTS root CUFTS
CUFTS www-data CUFTS
CUFTS postgres CUFTS
#########
# Command (fails through DBD::Pg, but also fails at command line)
#########
sudo -u postgres psql -U CUFTS CUFTS2