Re: what are those 3 passwords for ?

"arnuld uttre" <arnuld(dot)mizong(at)gmail(dot)com> writes:
> 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.
> It does not matter
> whether both passwords are same or different.
> because it always
> creates the user successfuly.

-P is about the password you intend to give to the new user. -W is
about the password of the user doing the creating.

I don't recommend using -W, because it will ask you for a password
whether or not the database is actually going to check that password.
This is more likely to be confusing than helpful. It would appear that
you are using an authentication method that doesn't require a password,
which is why it doesn't matter what you put in for -W.

regards, tom lane