X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 26A97D1D86C for ; Sun, 1 Feb 2004 22:14:54 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 28548-08 for ; Sun, 1 Feb 2004 18:14:53 -0400 (AST) Received: from hydra.nfcexperts.com (hydra.nfcexperts.com [208.48.34.69]) by svr1.postgresql.org (Postfix) with ESMTP id 0BE7CD1D841 for ; Sun, 1 Feb 2004 18:14:51 -0400 (AST) Received: from hydra.nfcnet (msa@localhost [127.0.0.1]) by hydra.nfcexperts.com (8.12.9p2/8.12.6) with ESMTP id i11MEkWf051239; Sun, 1 Feb 2004 17:14:46 -0500 (EST) (envelope-from msa@nfcexperts.com) Received: from localhost (msa@localhost) by hydra.nfcnet (8.12.9p2/8.12.9/Submit) with ESMTP id i11MEkd2051236; Sun, 1 Feb 2004 17:14:46 -0500 (EST) (envelope-from msa@nfcexperts.com) X-Authentication-Warning: hydra.nfcnet: msa owned process doing -bs Date: Sun, 1 Feb 2004 17:14:46 -0500 (EST) From: Michael Allman X-X-Sender: msa@hydra.nfcnet To: Bruce Momjian Cc: pgsql-admin@postgresql.org Subject: Re: HELP! Passwords stuck in passwd file! In-Reply-To: <200402012210.i11MAcj08300@candle.pha.pa.us> Message-ID: <20040201171142.S50944@hydra.nfcnet> References: <200402012210.i11MAcj08300@candle.pha.pa.us> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/4 X-Sequence-Number: 12178 As a matter of fact, I was able to "hack" passwd file support back in. It wasn't too hard, but if anyone is interested in seeing the patch, e-mail me privately. Michael On Sun, 1 Feb 2004, Bruce Momjian wrote: > Michael Allman wrote: > > I am migrating from 7.2 -> 7.4. I can't figure out how to move the > > crypt()'ed passwords I made with pg_password utility into the pg_shadow > > table. All I can find in the documentation is (in 7.3 release notes) > > > > Remove secondary password file capability and pg_password utility > > (Bruce) > > If I remember correctly, you can't. We now perfer MD5, where we can > store the information encrypted in the database, and use random salt > over the wire. > > We cant unencrypt the crypt values so unfortunately you have to reenter > them. You can do it using ALTER USER now. > > -- > Bruce Momjian | http://candle.pha.pa.us > pgman@candle.pha.pa.us | (610) 359-1001 > + If your life is a hard drive, | 13 Roberts Road > + Christ can be your backup. | Newtown Square, Pennsylvania 19073 >