Re: pg_connect troubles on localhost

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: John Taber <jtaber(at)johntaber(dot)net>
Cc: Jerry Sievers <jerry(at)jerrysievers(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: pg_connect troubles on localhost
Date: 2005-11-25 15:28:16
Message-ID: 22334.1132932496@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Greg Stark 2005-11-25 16:16:37 Re: regarding postmaster.pid file
Previous Message Martijn van Oosterhout 2005-11-25 14:22:05 Re: crosstab doesn't work