Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 78CE49FA60A for ; Tue, 17 Oct 2006 14:54:58 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 58526-06 for ; Tue, 17 Oct 2006 14:54:54 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from servata.com (ip-216-152-249-241.servata.com [216.152.249.241]) by postgresql.org (Postfix) with ESMTP id C83ED9FA4C9 for ; Tue, 17 Oct 2006 14:54:53 -0300 (ADT) Received: from [209.162.219.253] (helo=dogma.v10.wvs) by servata.com with esmtpa (Exim 4.50) id 1GZt9F-0000nF-Ht; Tue, 17 Oct 2006 10:54:41 -0700 Subject: Re: Database users Passwords From: Jeff Davis To: DEV Cc: pgsql-general@postgresql.org In-Reply-To: <008101c6f20c$f6babb80$0b01a8c0@LT003> References: <008101c6f20c$f6babb80$0b01a8c0@LT003> Content-Type: text/plain Date: Tue, 17 Oct 2006 10:54:41 -0700 Message-Id: <1161107681.31645.142.camel@dogma.v10.wvs> Mime-Version: 1.0 X-Mailer: Evolution 2.0.4 (2.0.4-7) Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.231 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO, SPF_HELO_PASS X-Spam-Level: X-Archive-Number: 200610/843 X-Sequence-Number: 102369 On Tue, 2006-10-17 at 12:54 -0400, DEV wrote: > Okay but the issue I have is that I have the passwords already generated and > in crypt() format and would love to just use them if at all possible? > PostgreSQL won't doesn't recognize crypt passwords, as far as I know. That means that it's pretty much impossible. Use a password recovery tool to get the plain text back, and encrypt it using md5. Regards, Jeff Davis