Re: CREATE USER ... - Mailing list pgsql-admin

From Tom Lane
Subject Re: CREATE USER ...
Date
Msg-id 25288.1103214346@sss.pgh.pa.us
Whole thread Raw
In response to CREATE USER ...  (CRI74 - Fabien Combernous <fc-tech@cri74.fr>)
List pgsql-admin
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

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: robust way of moving tables to a different disk??
Next
From: Tom Lane
Date:
Subject: Re: Notifications