Re: Ident authentication failed for user

On 03/01/12 10:03 AM, Ruben Blanco wrote:
> El día 1 de marzo de 2012 17:25, John R Pierce<pierce(at)hogranch(dot)com> escribió:
>> > On 03/01/12 9:02 AM, Ruben Blanco wrote:
>> > specify host=localhost, otherwise its using the first 'local' line, which
>> > specifies 'ident' authentication, as the error implies.
> Where should I specify "host=localhost"? in the $connection_string for
> pg_connect()? It doesn't work either.

I don''t do much PHP, so I might have the syntax wrong, but yes.... it
would go in the connection string passed to pg_Connection... however
you specify a host. if you don't give a host at all, it uses the
'domain' socket, which corresponds to the LOCAL line in pg_hba.conf...
if you specify host is localhost, then it uses the host .... 127.0.0.1
(or ::1) lines.

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