Re: Ident authentication failed for user

On 03/01/12 9:02 AM, Ruben Blanco wrote:
> I cannot connect to my Postgres database from my PHP scripts. I get the error:
>
> PHP Warning: pg_connect(): Unable to connect to PostgreSQL server:
> FATAL: Ident authentication failed for user "postgres" in ...
>
>
> I have tried many combinations for "host" TYPE in "pg_hba.conf"
> (restarting postmaster) without success:
>
> # TYPE DATABASE USER CIDR-ADDRESS METHOD
>
> # "local" is for Unix domain socket connections only
> local all all ident
>
> ...
> #host all all * trust
> host all all 127.0.0.1 255.255.255.255 trust
> #host all all localhost trust
> host all all ::1/128 trust
>
>
> Isn't the las record the less restrictive configuration for "host" connections?

specify host=localhost, otherwise its using the first 'local' line,
which specifies 'ident' authentication, as the error implies.

you do realize, trust lets any process on the localhost authenticate as
any user, including the postgres DBA account?

--
john r pierce N 37, W 122
santa cruz ca mid-left coast