Skip site navigation (1) Skip section navigation (2)

Re: PostgreSQL 8.2.3 Documentation - createuser - echoed command

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: Halley Pacheco de Oliveira <halleypo(at)yahoo(dot)com(dot)br>
Cc: pgsql-docs <pgsql-docs(at)postgresql(dot)org>
Subject: Re: PostgreSQL 8.2.3 Documentation - createuser - echoed command
Date: 2007-02-26 17:34:17
Message-ID: 200702261734.l1QHYHT00940@momjian.us (view raw or flat)
Thread:
Lists: pgsql-docs
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  <bruce(at)momjian(dot)us>          http://momjian.us
  EnterpriseDB                               http://www.enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +

In response to

pgsql-docs by date

Next:From: Tatsuo IshiiDate: 2007-03-02 05:32:11
Subject: broken doc
Previous:From: Halley Pacheco de OliveiraDate: 2007-02-25 10:23:37
Subject: PostgreSQL 8.2.3 Documentation - createuser - echoed command

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group