Re: installing on user account - Mailing list pgsql-admin

From Peter Eisentraut
Subject Re: installing on user account
Date
Msg-id 200608041810.45477.peter_e@gmx.net
Whole thread Raw
In response to installing on user account  ("Rodolfo Borges" <rodolfo.borges@gmail.com>)
Responses Re: installing on user account  ("Rodolfo Borges" <rodolfo.borges@gmail.com>)
List pgsql-admin
Am Freitag, 4. August 2006 17:57 schrieb Rodolfo Borges:
> $psql -U jabberd2 jabberd2
> psql: FATAL:  IDENT authentication failed for user "jabberd2"

You need to read up on configuring the client authentication.  If you don't
have root access, ident is probably not a good choice.  In particular ...

> I also tried appending a -W argument to that command.
> It asked for the password, I gave the password from the createuser
> command, and the same error ocurred.

... if you expect to use password authentication, you need to change the
client authentication mechanism away from ident and toward passwords.

--
Peter Eisentraut
http://developer.postgresql.org/~petere/

pgsql-admin by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: Background writer memory bloat?
Next
From: "Benjamin Krajmalnik"
Date:
Subject: Restoring dtabase problem