CRI74 - Fabien Combernous <fc-tech(at)cri74(dot)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