Thread: Authentication failed for user...

Friends

  I created a superuser "user1" and given permissions to create users and data bases. I then tried to connect the user
tothe data base "test" using the psql meta command "\c test user1" . The command returned the message "IDENT
Authenticationfailed for the user user1". Why this happens. How can i eliminate the problem? 

Thanks

On Fri, 2003-12-12 at 05:43, Manu M P wrote:
> Friends
>
>   I created a superuser "user1" and given permissions to create users
> and data bases. I then tried to connect the user to the data base
> "test" using the psql meta command "\c test user1" . The command
> returned the message "IDENT Authentication failed for the user user1".
> Why this happens. How can i eliminate the problem?

User authentication is controlled by the pg_hba.conf file in $PGDATA.
Read the manual chapter on Client Authentication.

Briefly, your system is set to check that users have the same names as
their UNIX login.  You will need to choose a different authentication
method to let you change identity with \c.

--
Oliver Elphick                                Oliver.Elphick@lfix.co.uk
Isle of Wight, UK                             http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839  932A 614D 4C34 3E1D 0C1C
                 ========================================
     "For thou art my hope, O Lord GOD; thou art my trust
      from my youth."               Psalms 71:5