SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-10-2008, 12:12 AM
| ||||
| ||||
 CREATE USER ... 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 ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match      |
|
04-10-2008, 12:12 AM
| ||||
| ||||
| 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 ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings |
Linear Mode
