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 82BD95638F for ; Wed, 2 Mar 2005 20:10:47 +0000 (GMT) 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 82513-02 for ; Wed, 2 Mar 2005 20:10:43 +0000 (GMT) Received: from web50408.mail.yahoo.com (web50408.mail.yahoo.com [206.190.38.73]) by svr1.postgresql.org (Postfix) with SMTP id 31E3E5636A for ; Wed, 2 Mar 2005 20:10:43 +0000 (GMT) Received: (qmail 8467 invoked by uid 60001); 2 Mar 2005 20:10:42 -0000 Comment: DomainKeys? See http://antispam.yahoo.com/domainkeys DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; b=5/uH0VJ0rQlGvRghs/lsJ/bxLTbo8X6ns9ZzVTYlLO2aGQhzRMi82fUEKgJqY0RZvKW0cFac2oqOZKI2VT3DKHILN6jan1MX/F+Tk2HZmNOpmwn3u31uuQE+KMLQ7T+dZqm3TFWs55yF8mEsKF/+wz3VDVCnbp5WHZx9YUx4VKI= ; Message-ID: <20050302201042.8465.qmail@web50408.mail.yahoo.com> Received: from [63.167.255.30] by web50408.mail.yahoo.com via HTTP; Wed, 02 Mar 2005 12:10:42 PST Date: Wed, 2 Mar 2005 12:10:42 -0800 (PST) From: Arcane_Rhino Subject: Fwd: Re: [GENERAL] pg_shadow passwd decrypt To: pgsql-admin@postgresql.org, pgsql-general@postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.374 tagged_above=0 required=5 tests=DNS_FROM_RFC_ABUSE X-Spam-Level: X-Archive-Number: 200503/32 X-Sequence-Number: 16530 One can, however, simply delete the forgotten password and create another for temporary usage until the user in question can create a new one. (At least one could in 7.4, I have not tried it in 8.0.) Jeff --- Bruce Momjian wrote: > From: Bruce Momjian > Subject: Re: [GENERAL] [ADMIN] pg_shadow passwd > decrypt > To: Hemapriya > Date: Wed, 2 Mar 2005 11:16:19 -0500 (EST) > CC: pgsql-admin@postgresql.org, > pgsql-general@postgresql.org > > Hemapriya wrote: > > Hi, > > > > Does postgres support any system functions that > > decode/decrypt the user passwords stored in > pg_shadow > > system catalog. > > > > Is there a way to retrieve the passwords, if > > forgotten. > > No. They are MD5 and are designed to be > unencryptable. > > -- > 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 > > ---------------------------(end of > broadcast)--------------------------- > TIP 9: the planner will ignore your desire to choose > an index scan if your > joining column's datatypes do not match >