X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id D8979D1B1C9 for ; Wed, 4 Aug 2004 02:22:08 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 11489-07 for ; Wed, 4 Aug 2004 05:21:22 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id 4D29BD1B1DF for ; Wed, 4 Aug 2004 02:20:34 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.11/8.12.11) with ESMTP id i745KUQK017074; Wed, 4 Aug 2004 01:20:30 -0400 (EDT) To: Steve Bergman Cc: pgsql-admin Subject: Re: md5 authentication working? In-reply-to: <1091588717.16009.14.camel@ip68-12-228-23.ok.ok.cox.net> References: <1091588717.16009.14.camel@ip68-12-228-23.ok.ok.cox.net> Comments: In-reply-to Steve Bergman message dated "Tue, 03 Aug 2004 22:05:17 -0500" Date: Wed, 04 Aug 2004 01:20:30 -0400 Message-ID: <17073.1091596830@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.1 tagged_above=0.0 required=5.0 tests=NO_DNS_FOR_FROM X-Spam-Level: * X-Archive-Number: 200408/15 X-Sequence-Number: 14410 Steve Bergman writes: > So, is my information old, and md5 is "just standard" now? It is default now. I think you'd need to say ALTER USER u WITH UNENCRYPTED PASSWORD 'foo' to push a cleartext password into pg_shadow. (There may also still be a postgresql.conf setting that affects this, but I'm too lazy to go look.) regards, tom lane