Re: pg_connect troubles on localhost - Mailing list pgsql-general

From John Taber
Subject Re: pg_connect troubles on localhost
Date
Msg-id 43876CC7.6080301@johntaber.net
Whole thread Raw
In response to Re: pg_connect troubles on localhost  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
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@johntaber.net> 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
>
>

pgsql-general by date:

Previous
From: Manuel Sugawara
Date:
Subject: Re: Regular expressions w localization problem
Next
From: CSN
Date:
Subject: Can this pl/pgsql be simplified?