From: Bruce Momjian <bruce@momjian.us>
To: Halley Pacheco de Oliveira <halleypo@yahoo.com.br>
Cc: pgsql-docs <pgsql-docs@postgresql.org>
Subject: Re: PostgreSQL 8.2.3 Documentation - createuser - echoed command
Date: Mon, 26 Feb 2007 12:34:17 -0500 (EST)
Message-ID: <200702261734.l1QHYHT00940@momjian.us> (raw)
In-Reply-To: <389229.32208.qm@web51814.mail.yahoo.com>
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@momjian.us> http://momjian.us
EnterpriseDB http://www.enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-docs@postgresql.org
Cc: bruce@momjian.us, halleypo@yahoo.com.br
Subject: Re: PostgreSQL 8.2.3 Documentation - createuser - echoed command
In-Reply-To: <200702261734.l1QHYHT00940@momjian.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox