| From: | Weiwei Guo <wwguocn(at)gmail(dot)com> |
|---|---|
| To: | pgsql-novice(at)postgresql(dot)org |
| Subject: | What is a password for? |
| Date: | 2008-03-16 05:31:40 |
| Message-ID: | 47DCB0BC.5060009@gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
Dear all,
I am trying to create user/db under console with. I find that no matter I input a password or not when I'm creating or
dropping a user/db, the action can be success. What is a password for?
The following is what I have done:
~ $ createuser -U postgres -W super_creater_ctreated
Shall the new role be a superuser? (y/n) n
Shall the new role be allowed to create databases? (y/n) y
Shall the new role be allowed to create more new roles? (y/n) y
Password:<I input 'aaa' here>
CREATE ROLE
~ $ createuser -U super_creater_ctreated -W test_creater_created
Shall the new role be a superuser? (y/n) n
Shall the new role be allowed to create databases? (y/n) y
Shall the new role be allowed to create more new roles? (y/n) n
Password: <i input 'bbb' here>
CREATE ROLE
~ $ dropuser -U super_creater_ctreated -W test_creater_created
Password:<i input nothing here>
DROP ROLE
~ $ createuser -U super_creater_ctreated -W test_creater_createdno
Shall the new role be a superuser? (y/n) n
Shall the new role be allowed to create databases? (y/n) y
Shall the new role be allowed to create more new roles? (y/n) n
Password:<i input nothing here>
CREATE ROLE
~ $ dropuser -U super_creater_ctreated -W test_creater_createdno
Password:<i input 'bbb' here>
DROP ROLE
I cannot understand the mechanism for password. Is it a bug?
I'm using postgresql-8.2.6.
Weiwei
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Micah Yoder | 2008-03-16 05:48:02 | Re: What is a password for? |
| Previous Message | Frank Bax | 2008-03-15 15:55:07 | Re: Initialization on server start-up |