Re: createuser problem in 7.3.4 on Linux - Mailing list pgsql-admin

From A.Bhuvaneswaran
Subject Re: createuser problem in 7.3.4 on Linux
Date
Msg-id 1071657087.1831.6.camel@Bhuvan.bksys.co.in
Whole thread Raw
In response to createuser problem in 7.3.4 on Linux  (Paul Power <paulp127@dublin.ie>)
List pgsql-admin
> As user postgres I have run initdb. I create a user named
> Administrator via the createuser script. All goes well and I get the
> response CREATE USER.
> Then I try:
>
> psql -U Administrator template1
>
> and get the response:
> psql: FATAL: IDENT authentication failed for user "Administrator".
>

Default installation uses ident authentication method. It requires os
user with the same name & mapping in pg_ident.conf. If i am correct, you
are looking for either trust/password authentication method. If so, edit
pg_hba.conf and comment the ident entry and uncomment trust entry.


> ERROR: DROP USER: user "administrator" does not exist

It looks strange. Ensure, you are not deleting the user twice -:).
Since, IMO, both createuser and dropuser scripts handle the case
properly.

regards,
bhuvaneswaran


Attachment

pgsql-admin by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: createuser problem in 7.3.4 on Linux
Next
From: "A.Bhuvaneswaran"
Date:
Subject: Re: createuser problem in 7.3.4 on Linux