In response to "arnuld uttre" <arnuld.mizong@gmail.com>:
> I see postgres has 3 password mechanism:
>
> 'createuser -d -P arnuld' -- which will ask for the password
> according to P flag used here.
> 'createuser -d -P -W arnuld' -- which will ask for the 2 passwords
> belonging to P and W flags.
In order to create a user, you have to connect as an existing user.
When you use -W, you tell the createuser command to _always_ prompt
for the (existing) password before allowing you to connect, even if
your configuration does not require password authentication.
So, even with the second command, you're still only using 1 password
when you create the account. I feel that the man page for createuser
explains this pretty well.
--
Bill Moran
Collaborative Fusion Inc.
http://people.collaborativefusion.com/~wmoran/
wmoran@collaborativefusion.com
Phone: 412-422-3463x4023