From: | "A(dot)Bhuvaneswaran" <bhuvan(at)symonds(dot)net> |
---|---|
To: | paulp127(at)dublin(dot)ie |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: createuser problem in 7.3.4 on Linux |
Date: | 2003-12-17 10:31:28 |
Message-ID: | 1071657087.1831.6.camel@Bhuvan.bksys.co.in |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | A.Bhuvaneswaran | 2003-12-17 11:18:16 | Re: createuser problem in 7.3.4 on Linux |
Previous Message | Peter Eisentraut | 2003-12-17 10:26:03 | Re: createuser problem in 7.3.4 on Linux |