Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id E5C80633681 for ; Tue, 17 Nov 2009 17:43:35 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 21925-01 for ; Tue, 17 Nov 2009 21:43:28 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from smtp.comsquared.com (smtp.comsquared.com [209.155.237.140]) by mail.postgresql.org (Postfix) with ESMTP id 99CAB633F23 for ; Tue, 17 Nov 2009 17:43:27 -0400 (AST) Received: from mdpserv.comsquared.com (mdpserv [10.82.40.1]) by smtp.comsquared.com (Switch-3.2.7/Switch-3.2.7) with ESMTP id nAHLhLR2021125 for ; Tue, 17 Nov 2009 16:43:24 -0500 (EST) Received: from erouse052008 (erouse052008.ntc2s.comsquared.com [10.82.60.61]) by mdpserv.comsquared.com (8.13.6+Sun/8.13.6) with ESMTP id nAHLhL6h029850; Tue, 17 Nov 2009 16:43:21 -0500 (EST) From: "Edward W. Rouse" To: "'Edward W. Rouse'" , References: <00b501ca67cb$d8efd9e0$8acf8da0$@com> In-Reply-To: <00b501ca67cb$d8efd9e0$8acf8da0$@com> Subject: Re: lost password Date: Tue, 17 Nov 2009 16:43:20 -0500 Message-ID: <00c001ca67ce$fb3fd970$f1bf8c50$@com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_00C1_01CA67A5.1269D170" X-Mailer: Microsoft Office Outlook 12.0 Thread-Index: Acpny9jAbfOmwqNaSjWmw072HC8O4QAApuZA Content-Language: en-us X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.002 tagged_above=-10 required=5 tests=BAYES_50=0.001, HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 200911/42 X-Sequence-Number: 33393 This is a multi-part message in MIME format. ------=_NextPart_000_00C1_01CA67A5.1269D170 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Well I quickly found out 2 things: 1. You can copy the md5 over and have it work 2. The same password can have different md5's After I copied the md5 over I played around a bit and found the for the process user. I then used the alter user sql statement and rechecked the md5. It was different, but I could still use the same password to log in. Needless to say, I am a bit confused by that, but it works and that's what I need. Edward W. Rouse From: pgsql-sql-owner@postgresql.org [mailto:pgsql-sql-owner@postgresql.org] On Behalf Of Edward W. Rouse Sent: Tuesday, November 17, 2009 4:21 PM To: pgsql-sql@postgresql.org Subject: [SQL] lost password I have a database that has a "process" user. I need to move the database to an additional server. When I restore it gave me a "user not found" error. So I am trying to recreate this user, but no one knows what the password is supposed to be. The processes connecting to it have encrypted versions of the password. And what I can find in the database uses md5. Is there some way to find out or copy over the users password? Trying to find every process that uses this login will be very time consuming and we are guaranteed to miss some and generate a lot of frustration and confusion as processes that always worked cease. Not to mention that some stuff may be failing for a while before someone catches it. I was thinking of just taking the md5 from pg_authid:rolpassword and using it to update the new server. Will this work? Or is there another way to retrieve a forgotten password? Edward W. Rouse Comsquared System, Inc. 770-734-5301 ------=_NextPart_000_00C1_01CA67A5.1269D170 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Well I quickly found = out 2 things:

1. You can = copy the md5 over and have it work

2. The same = password can have different md5’s

After I copied the = md5 over I played around a bit and found the for the process user. I then used the = alter user sql statement and rechecked the md5. It was different, but I could = still use the same password to log in. Needless to say, I am a bit confused by = that, but it works and that’s what I need.

Edward W. = Rouse

From:= = pgsql-sql-owner@postgresql.org [mailto:pgsql-sql-owner@postgresql.org] On Behalf Of Edward W. = Rouse
Sent: Tuesday, November 17, 2009 4:21 PM
To: pgsql-sql@postgresql.org
Subject: [SQL] lost password

I have a database that has a “process” = user. I need to move the database to an additional server. When I restore it = gave me a “user not found” error. So I am trying to recreate this = user, but no one knows what the password is supposed to be. The processes = connecting to it have encrypted versions of the password. And what I can find in the = database uses md5. Is there some way to find out or copy over the users password? = Trying to find every process that uses this login will be very time consuming = and we are guaranteed to miss some and generate a lot of frustration and = confusion as processes that always worked cease. Not to mention that some stuff may = be failing for a while before someone catches it.

I was thinking of just taking the md5 from pg_authid:rolpassword and using it to update the new server. Will this = work? Or is there another way to retrieve a forgotten password?

Edward W. Rouse

Comsquared System, Inc.

770-734-5301

------=_NextPart_000_00C1_01CA67A5.1269D170--