> 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