In response to "arnuld uttre" <arnuld.mizong@xxxxxxxxx>: > 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@xxxxxxxxxxxxxxxxxxxxxxx Phone: 412-422-3463x4023 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
