| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Alain-Serge Nagni <akenaton(at)freesurf(dot)ch> |
| Cc: | pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: Postgresql Novice problem |
| Date: | 2004-05-28 16:41:03 |
| Message-ID: | 27849.1085762463@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
Alain-Serge Nagni <akenaton(at)freesurf(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2004-05-28 17:02:17 | Re: Error msgs from PostgreSQL server : specified item offset is too large, failed to add item to the page |
| Previous Message | Alain-Serge Nagni | 2004-05-28 16:17:59 | Postgresql Novice problem |