Re: Postgresql Novice problem - Mailing list pgsql-novice

From Tom Lane
Subject Re: Postgresql Novice problem
Date
Msg-id 27849.1085762463@sss.pgh.pa.us
Whole thread Raw
In response to Postgresql Novice problem  (Alain-Serge Nagni <akenaton@freesurf.ch>)
Responses Re: Postgresql Novice problem
List pgsql-novice
Alain-Serge Nagni <akenaton@freesurf.ch> writes:
> But when a I try to use the Datamanager to get access to the database, it's
> looks impossible. I got an error message: [unixODBC]FATAL: IDENT
> authentication failed for user "newuser".

If you're using IDENT authentication then you can't log in under a
Postgres username that's different from your real (Unix) username.

(At least, not without fooling around with creating an ident user map,
which is probably more trouble than you want to go to.)

I'd suggest setting up your pg_hba.conf file so that this connection
is checked using passwords instead of IDENT.

            regards, tom lane

pgsql-novice by date:

Previous
From: Alain-Serge Nagni
Date:
Subject: Postgresql Novice problem
Next
From: Alain-Serge Nagni
Date:
Subject: Re: Postgresql Novice problem