pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedCREATE USER ...
2+ messages / 2 participants
[nested] [flat]
* CREATE USER ...
@ 2004-12-16 10:41 CRI74 - Fabien Combernous <fc-tech@cri74.fr>
0 siblings, 1 reply; 2+ messages in thread
From: CRI74 - Fabien Combernous @ 2004-12-16 10:41 UTC (permalink / raw)
To: pgsql-admin
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
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: CREATE USER ...
@ 2004-12-16 16:25 Tom Lane <tgl@sss.pgh.pa.us>
parent: CRI74 - Fabien Combernous <fc-tech@cri74.fr>
0 siblings, 0 replies; 2+ messages in thread
From: Tom Lane @ 2004-12-16 16:25 UTC (permalink / raw)
To: CRI74 - Fabien Combernous <fc-tech@cri74.fr>; +Cc: 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
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2004-12-16 16:25 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-12-16 10:41 CREATE USER ... CRI74 - Fabien Combernous <fc-tech@cri74.fr>
2004-12-16 16:25 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox