Re: what are those 3 passwords for ?

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