| From: | Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com> |
|---|---|
| To: | Partha Sur <p(dot)sur(at)worldnet(dot)att(dot)net> |
| Cc: | pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: createuser problem |
| Date: | 2003-09-27 05:12:23 |
| Message-ID: | 20030926220956.F41746@megazone.bigpanda.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
On Fri, 26 Sep 2003, Partha Sur wrote:
> Now try to connect to database "mytest" as user "psur"
>
> -bash-2.05b$ psql -U psur mytest
> psql:FATAL:IDENT authentication failed for user "psur"
> -bash-2.05b$
>
> Perhaps database user "psur" not allowed to attach to database "mytest"
> (which was created under CURRENT_USER = "postgres") ... Is this true ?
It looks like your pg_hba.conf is set to want some form of ident style
authentication from the message. You'd probably need to try logging in to
the psur account from a unix account named psur or changing the
authentication in pg_hba.conf.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Oliver Elphick | 2003-09-27 05:26:35 | Re: createuser problem |
| Previous Message | Partha Sur | 2003-09-27 03:37:58 | Fw: createuser problem (7.3.2) |