Hmmm, I have no idea what the Apache daemon user is(root?) but not sure
how to check. So what would be the workaround ? Should I setup users
as different from OS user names ?
Tom Lane wrote:
John Taber <jtaber@xxxxxxxxxxxxx> writes:
# TYPE DATABASE USER CIDR-ADDRESS METHOD
# "local" is for Unix domain socket connections only
local all all ident sameuser
"ident sameuser" means you can only connect as the PG user with the same
name as the operating system account that's running the program you try
to connect from. (In the case of a PHP program that's probably going to
be the Apache daemon user.) Passwords are not relevant for ident auth.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings