> 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
signature.asc
Description: This is a digitally signed message part
