Re: pg_connect troubles on localhost

From: John Taber <jtaber(at)johntaber(dot)net>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: pg_connect troubles on localhost
Date: 2005-11-25 19:57:59
Message-ID: 43876CC7.6080301@johntaber.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)johntaber(dot)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
>
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message CSN 2005-11-25 20:19:01 Can this pl/pgsql be simplified?
Previous Message Tom Lane 2005-11-25 19:21:01 Re: Regular expressions w localization problem