Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 6317D9FA3A3 for ; Tue, 17 Oct 2006 18:15:42 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 19193-10 for ; Tue, 17 Oct 2006 18:15:37 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from servata.com (ip-216-152-249-241.servata.com [216.152.249.241]) by postgresql.org (Postfix) with ESMTP id 383EA9FA38F for ; Tue, 17 Oct 2006 18:15:37 -0300 (ADT) Received: from [209.162.219.253] (helo=dogma.v10.wvs) by servata.com with esmtpa (Exim 4.50) id 1GZwHV-0006mF-Tt; Tue, 17 Oct 2006 14:15:26 -0700 Subject: Re: [GENERAL] Database users Passwords From: Jeff Davis To: Peter Eisentraut Cc: pgsql-docs@postgresql.org, DEV In-Reply-To: <200610172135.55731.peter_e@gmx.net> References: <002c01c6f1fa$652d3f60$0b01a8c0@LT003> <1161102985.31645.100.camel@dogma.v10.wvs> <200610172135.55731.peter_e@gmx.net> Content-Type: text/plain Date: Tue, 17 Oct 2006 14:15:23 -0700 Message-Id: <1161119723.31645.186.camel@dogma.v10.wvs> Mime-Version: 1.0 X-Mailer: Evolution 2.0.4 (2.0.4-7) Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.23 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO, SPF_HELO_PASS X-Spam-Level: X-Archive-Number: 200610/31 X-Sequence-Number: 3752 On Tue, 2006-10-17 at 21:35 +0200, Peter Eisentraut wrote: > Jeff Davis wrote: > > This seems to be lacking in the docs. At least, the only place I > > found this information was a user comment in the 8.0 docs. Is this > > already in the 8.1 docs? Should we add a description of the way > > postgresql does the md5 hashes in the CREATE ROLE section? > > This has been in the documentation at least as far back as 7.3. > I took a second look, and I am not seeing anything in the CREATE ROLE docs that say you need to concatenate the user to the password before encrypting with md5. I saw that in a comment in the 8.0 docs, but I can't find it in the 8.1 docs. Can you please point me to a specific section? Regards, Jeff Davis