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