In the createuser command page is written:
To create the user joe as a superuser, and assign a password immediately:
$ createuser -P -s -e joe
Enter password for new role: xyzzy
Enter it again: xyzzy
CREATE ROLE joe PASSWORD 'xyzzy' SUPERUSER CREATEDB CREATEROLE INHERIT LOGIN;
CREATE ROLE
In the above example, the new password isn't actually echoed when typed, but we show what was typed for clarity.
Howeverthe password will appear in the echoed command, as illustrated so you don't want to use -e when assigning a
password,if anyone else can see your screen.
But it is not always the truth.
When I use
$ createuser -P -s -N -e joe
I get:
Enter password for new role: xyzzy
Enter it again: xyzzy
CREATE ROLE joe PASSWORD 'xyzzy' SUPERUSER CREATEDB CREATEROLE INHERIT LOGIN;
CREATE ROLE
(same as in the documentation)
But when I use
$ createuser -P -s -E -e joe
(or don't use -N or -E) I get:
CREATE ROLE joe ENCRYPTED PASSWORD 'md5b5f5ba1a423792b526f799ae4eb3d59e' SUPERUSER CREATEDB CREATEROLE INHERIT LOGIN;
(the password is shown encrypted)
The last two examples were executed using a "createuser (PostgreSQL) 8.2.0" local.
But when I execute the createuser command from a remote machine using:
# createuser --version
createuser (PostgreSQL) 8.1.4
# createuser -h Kubuntu -U sistemas -P -s -E -e joe
I get:
CREATE ROLE joe ENCRYPTED PASSWORD 'xyzzy' SUPERUSER CREATEDB CREATEROLE INHERIT LOGIN;
(same as in the documentation, but different from the createuser 8.2.0 local)
I would like to know the reason of the difference. Is it being caused by the different versions of createuser?
The text is the same in the PostgreSQL 8.1.8 Documentation and in the PostgreSQL 8.2.3 Documentation, but it seems to
methat the createuser behaviour is different in these versions.
Thanks,
Halley
__________________________________________________
Fale com seus amigos de graça com o novo Yahoo! Messenger
http://br.messenger.yahoo.com/
