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 233645637C for ; Wed, 2 Mar 2005 16:06:57 +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 08648-07 for ; Wed, 2 Mar 2005 16:06:52 +0000 (GMT) Received: from web21324.mail.yahoo.com (web21324.mail.yahoo.com [216.136.175.210]) by svr1.postgresql.org (Postfix) with SMTP id C2DDA52A5A for ; Wed, 2 Mar 2005 16:06:51 +0000 (GMT) Received: (qmail 76125 invoked by uid 60001); 2 Mar 2005 16:06:48 -0000 Comment: DomainKeys? See http://antispam.yahoo.com/domainkeys DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; b=FHrI5xrykBe8aALehU1ZuO9FWHS4C2ObmT6fYxLBj1ST7NEQQgOpVjVkxP8q2UqhsD4iegkIZIeqbcPQMoohr0MIkVSMZXnes7duuBpDPMuSHTklT8OAwk+vrwNt6BS0LnxmtcWsvTWub7vLSUGTQGAKEFQSxBT+Vlxh674u4fQ= ; Message-ID: <20050302160648.76123.qmail@web21324.mail.yahoo.com> Received: from [64.59.17.210] by web21324.mail.yahoo.com via HTTP; Wed, 02 Mar 2005 08:06:48 PST Date: Wed, 2 Mar 2005 08:06:48 -0800 (PST) From: Hemapriya Subject: 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.796 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE, FROM_ENDS_IN_NUMS X-Spam-Level: X-Archive-Number: 200503/28 X-Sequence-Number: 16526 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. Thanks in Advance. Priya __________________________________ Celebrate Yahoo!'s 10th Birthday! Yahoo! Netrospective: 100 Moments of the Web http://birthday.yahoo.com/netrospective/