Re: what are those 3 passwords for ?

In response to "arnuld uttre" <arnuld(dot)mizong(at)gmail(dot)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(at)collaborativefusion(dot)com
Phone: 412-422-3463x4023