Search Postgresql Archives

Re: pg_connect troubles on localhost

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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




[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux