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

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

pgsql-general by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: crosstab doesn't work
Next
From: Greg Stark
Date:
Subject: Re: regarding postmaster.pid file