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

From Rodolfo Borges
Subject Re: installing on user account
Date
Msg-id 4b315f820608041048w7e58ea92n11c9db6b659abcbf@mail.gmail.com
Whole thread Raw
In response to Re: installing on user account  (Peter Eisentraut <peter_e@gmx.net>)
Responses Re: installing on user account  ("Rodolfo Borges" <rodolfo.borges@gmail.com>)
List pgsql-admin
On 8/4/06, Peter Eisentraut <peter_e@gmx.net> wrote:
> 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 ...

But that's a postgres global setting, not a database-specific setting, right?
So, I would need root access to change it.

Back from lunch now, I'll proceed with the installation of my own
postgres on my $HOME.

> > 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.

Thanks for the tip.

--
Rodolfo Borges

pgsql-admin by date:

Previous
From: RPK
Date:
Subject: Problem in starting PGSQL8.1 service.
Next
From: Ivo Rossacher
Date:
Subject: Re: Restoring dtabase problem