X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 38663D1C919 for ; Wed, 31 Dec 2003 17:32:56 +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 12978-05 for ; Wed, 31 Dec 2003 13:32:06 -0400 (AST) Received: from jumpline.com (s5.n4.vds2000.com [66.84.4.5]) by svr1.postgresql.org (Postfix) with ESMTP id 62DD0D1B436 for ; Wed, 31 Dec 2003 13:32:04 -0400 (AST) Received: from kenny.jlhome.com (kenny.jlhome.com [65.112.77.20]) by jumpline.com (8.12.5/8.11.0) with SMTP id hBVHW1F3014796; Wed, 31 Dec 2003 12:32:02 -0500 X-Authentication-Warning: jumpline.com: jumpline owned process doing -bs Subject: Re: forcing postgresql 7.3 to use crypt passwords From: Kenny Drobnack To: Tom Lane Cc: pgsql-admin@postgresql.org In-Reply-To: <11189.1072891206@sss.pgh.pa.us> References: <1072887163.40.4.camel@kenny.jlhome.com> <11189.1072891206@sss.pgh.pa.us> Content-Type: text/plain Organization: Jumpline.com Message-Id: <1072891915.13899.10.camel@kenny.jlhome.com> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.5 Date: Wed, 31 Dec 2003 12:31:56 -0500 Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200312/357 X-Sequence-Number: 11863 On Wed, 2003-12-31 at 12:20, Tom Lane wrote: > Kenny Drobnack writes: > > We currently have multiple databases running different versions of > > postgresql ranging from version 7.1 to 7.3. When we create users in 7.3 > > databases, it encrypts their passwords with md5, which is not supported > > in 7.1. Is there some way to force postgresql 7.3 to use the old crypt > > encryption for passwords when creating users? > > AFAIR the previous approach was not to encrypt passwords at all in > pg_shadow. You can still do that with ALTER USER ... UNENCRYPTED PASSWORD > (also there's a setting to make this the default behavior). > > regards, tom lane Thanks! I got it figured out. I add "password_encryption = false" to postgresql.conf and did ALTER USER ... PASSWORD on all the users. Then, found some docs that said the crypt encryption option only encrypts passwords going across network connections, not in the database. So I've set that as the authorization method in pg_hba.conf. So we've got passwords encrypted everywhere except in pg_shadow. It'll due till we get everything upgraded to 7.3 or preferably 7.4. -- Kenny