Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 322429FB72C for ; Sun, 25 Feb 2007 06:30:23 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-new, port 10024) with ESMTP id 44324-07 for ; Sun, 25 Feb 2007 06:30:20 -0400 (AST) X-Greylist: delayed 00:06:41.172921 by SQLgrey-1.7.4 Received: from web51814.mail.yahoo.com (web51814.mail.yahoo.com [206.190.39.233]) by postgresql.org (Postfix) with SMTP id CAF599FB613 for ; Sun, 25 Feb 2007 06:30:19 -0400 (AST) Received: (qmail 32365 invoked by uid 60001); 25 Feb 2007 10:23:37 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com.br; h=X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID; b=Ma1Bg9pZwM6iud+8BHQrogQMdTaVnZCwC3TQ5lncTwQF9ZBi/NO4PJ/i5VxPkuHxCuXh6GE6A+ior7ccdEEeZCs5SIXnzfo7a/JNR4P4qAE9kEsaZkDsLt8b2oYCI0DKgWl1LG4yJ1KRw42DZ7GdOSzv3fDb/PYPCK/qZCp8kOs=; X-YMail-OSG: J8pDpF4VM1m82Gg.8zyf7SkuqAh2_NtS5LI84oyV9.V8YNP_i5tAkNTT1xOKiyAX_CQSpwQnKaGIXR2nq9Y_UjCW23OM4uKn8mQGMQ5u8scGH0tMlYEhUPAeDLojW9_1BOaTfcx9HEIXdo3DGJ4YlE0jUw-- Received: from [201.53.21.104] by web51814.mail.yahoo.com via HTTP; Sun, 25 Feb 2007 02:23:37 PST X-Mailer: YahooMailRC/368.8 YahooMailWebService/0.6.132.8 Date: Sun, 25 Feb 2007 02:23:37 -0800 (PST) From: Halley Pacheco de Oliveira Subject: PostgreSQL 8.2.3 Documentation - createuser - echoed command To: pgsql-docs MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable Message-ID: <389229.32208.qm@web51814.mail.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.201 tagged_above=0 required=5 tests=BAYES_50, DNS_FROM_RFC_ABUSE X-Spam-Level: X-Archive-Number: 200702/39 X-Sequence-Number: 4170 In the createuser command page is written:=0A=0ATo create the user joe as a= superuser, and assign a password immediately:=0A=0A$ createuser -P -s -e j= oe=0AEnter password for new role: xyzzy=0AEnter it again: xyzzy=0ACREATE RO= LE joe PASSWORD 'xyzzy' SUPERUSER CREATEDB CREATEROLE INHERIT LOGIN;=0ACREA= TE ROLE=0A=0AIn the above example, the new password isn't actually echoed w= hen typed, but we show what was typed for clarity. However the password wil= l appear in the echoed command, as illustrated =97 so you don't want to use= -e when assigning a password, if anyone else can see your screen.=0A=0ABut= it is not always the truth.=0A=0AWhen I use=0A=0A$ createuser -P -s -N -e = joe=0A=0AI get:=0A=0AEnter password for new role: xyzzy=0AEnter it again: x= yzzy=0ACREATE ROLE joe PASSWORD 'xyzzy' SUPERUSER CREATEDB CREATEROLE INHER= IT LOGIN;=0ACREATE ROLE=0A=0A(same as in the documentation)=0A=0ABut when I= use=0A=0A$ createuser -P -s -E -e joe=0A=0A(or don't use -N or -E) I get:= =0A=0A=0ACREATE ROLE joe ENCRYPTED PASSWORD 'md5b5f5ba1a423792b526f799ae4eb= 3d59e' SUPERUSER CREATEDB CREATEROLE INHERIT LOGIN;=0A=0A(the password is s= hown encrypted)=0A=0AThe last two examples were executed using a "createuse= r (PostgreSQL) 8.2.0" local.=0A=0ABut when I execute the createuser command= from a remote machine using:=0A=0A# createuser --version=0Acreateuser (Pos= tgreSQL) 8.1.4=0A=0A# createuser -h Kubuntu -U sistemas -P -s -E -e joe=0A= =0AI get:=0A=0ACREATE ROLE joe ENCRYPTED PASSWORD 'xyzzy' SUPERUSER CREATED= B CREATEROLE INHERIT LOGIN;=0A=0A(same as in the documentation, but differe= nt from the createuser 8.2.0 local)=0A=0AI would like to know the reason of= the difference. Is it being caused by the different versions of createuser= ?=0A=0AThe text is the same in the PostgreSQL 8.1.8 Documentation and in th= e PostgreSQL 8.2.3 Documentation, but it seems to me that the createuser be= haviour is different in these versions.=0A=0AThanks,=0AHalley=0A=0A=0A=0A= =0A=0A__________________________________________________=0AFale com seus am= igos de gra=E7a com o novo Yahoo! Messenger =0Ahttp://br.messenger.yahoo.c= om/