Re: createuser problem

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.