#############
# 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