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. However the 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 me that 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/ ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
