Re: CREATE USER ...

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