Обсуждение: CREATE USER ...

Hello,

I'm trying to create new user. What is wrong in this ?

template1=# CREATE USER sympa WITH UNENCRYPTED PASSWORD 'kiki'
NOCREATEDB NOCREATEUSER;
CREATE USER
template1=# \c - sympa
Password:
FATAL 1:  Password authentication failed for user "sympa"

Previous connection kept
template1=#

In log file i see : "verify_password: user 'sympa' not found in password
file."


Then to verify that user is created i tried this :
CREATE USER sympa WITH UNENCRYPTED PASSWORD 'kiki' NOCREATEDB NOCREATEUSER;
ERROR:  CREATE USER: user name "sympa" already exists
template1=#

--
IT ressources center of Haute Savoie
Saleve Building, International Business parc of Archamps, France
Tel : +33450315630 - Fax : +33450953817 - http://www.cri74.fr

CRI74 - Fabien Combernous <fc-tech@cri74.fr> writes:
> template1=# CREATE USER sympa WITH UNENCRYPTED PASSWORD 'kiki'
> NOCREATEDB NOCREATEUSER;
> CREATE USER
> template1=# \c - sympa
> Password:
> FATAL 1:  Password authentication failed for user "sympa"

Perhaps you did this inside a BEGIN block, and forgot to COMMIT?

            regards, tom lane