The -E/-N options control how the password is stored in the server, and that is what you are seeing in different ENCRYPTED PASSWORD entries.
Generally, you should never use -N. --------------------------------------------------------------------------- Halley Pacheco de Oliveira wrote: > 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 -- Bruce Momjian <[EMAIL PROTECTED]> http://momjian.us EnterpriseDB http://www.enterprisedb.com + If your life is a hard drive, Christ can be your backup. + ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
