Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 7F87A9F9F0E for ; Sat, 2 Dec 2006 15:51:27 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-new, port 10024) with ESMTP id 61540-10 for ; Sat, 2 Dec 2006 15:51:19 -0400 (AST) X-Greylist: delayed 00:06:36.893908 by SQLgrey-1.7.4 Received: from web90513.mail.mud.yahoo.com (web90513.mail.mud.yahoo.com [216.252.100.180]) by postgresql.org (Postfix) with SMTP id A7A439F9392 for ; Sat, 2 Dec 2006 15:51:18 -0400 (AST) Received: (qmail 66467 invoked by uid 60001); 2 Dec 2006 19:44:38 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID; b=0SEJRGk92YFpf/PBxVN3o1AORPi8RAVt5U5Pd+vlaGM4Y3haQSOn6dsTKq0stToXOeHtHKJWmtUI1oaES6CGzvczLsigNNthQTBs5cqUeLw/m2k/e3yZC4rrSwmn7vQtKYLG0YOTQaNhl2dbKIjuYDAvVVryFbzIHGlNtDoAJPc=; X-YMail-OSG: S05Uw_IVM1lMD1xUc_ChZ2ywjUAHwvzEgL_JKI1SVH50glHvJVbNQsaGz.zglzaeZnZcnxA6iLlWxsEw.4qnUyo2e_UD2w_AH15QdjInDx_3ceX0mgCoZw-- Received: from [70.19.69.82] by web90513.mail.mud.yahoo.com via HTTP; Sat, 02 Dec 2006 11:44:38 PST Date: Sat, 2 Dec 2006 11:44:38 -0800 (PST) From: Philippe Salama Subject: Lost password to user postgres To: pgsql-admin@postgresql.org MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-2036407165-1165088678=:66455" Content-Transfer-Encoding: 8bit Message-ID: <638600.66455.qm@web90513.mail.mud.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=2.108 tagged_above=0 required=5 tests=BAYES_00, DNS_FROM_RFC_ABUSE, DNS_FROM_RFC_POST, DNS_FROM_RFC_WHOIS, HTML_10_20, HTML_MESSAGE X-Spam-Level: ** X-Archive-Number: 200612/19 X-Sequence-Number: 23811 --0-2036407165-1165088678=:66455 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit 2 years ago, I installed postgresql on my desktop and used it for a while for learning purposes. Then, I stopped using it. I forgot the password to the user postgres Now, I am doing a lot with Microsoft Access, and participate a lot at utteraccess.com Last night I installed MySQL, and am using it for some learning exercises. I would very much like to connect to my existing installation of PostgresQL, but I have lost the password. One of the admin programs is still working, and connects to the server, but of course the password is concealed. HERE IS WHAT I WANT TO DO. I dont care about the old data in the server. I just want to have total access to it again as admin. I DO NOT want to uninstall and reinstall, if possible. Is there ANY WAY to recover my password, or reset the server, without going through an uninstall/reinstall process. IF it is the case that I MUST uninstall and then reinstall, are there any caveats. I saw one post in google from someone who lost his password, and had all sorts of hassels uninstalling and reinstalling. Also, if it is the case that I must reinstall, should I use the install download that I still have from 2 years ago. I remember going through SHEAR TORTURE plowing through all the websites, with all the obscure technical jargon, to find the proper windows install to download. Perhaps things have improved in two years. The MySQL install was effortless, up and working in 30 minutes, with no reference to instructions or help. Anyway, I would appreciate your advice. If you are Access users, hope you can stop by http://utteraccess.com some time and say hello. Thanks --------------------------------- Want to start your own business? Learn how on Yahoo! Small Business. --0-2036407165-1165088678=:66455 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: 8bit 2 years ago, I installed postgresql on my desktop and used it for a while for learning purposes.  Then, I stopped using it.  I forgot the password to the user postgres

Now, I am doing a lot with Microsoft Access, and participate a lot at utteraccess.com

Last night I installed MySQL, and am using it for some learning exercises.  I would very much like to connect to my existing installation of PostgresQL, but I have lost the password.  One of the admin programs is still working, and connects to the server, but of course the password is concealed.

HERE IS WHAT I WANT TO DO. I dont care about the old data in the server. I just want to have total access to it again as admin.  I DO NOT want to uninstall and reinstall, if possible.   Is there ANY WAY to recover my password, or reset the server, without going through an uninstall/reinstall process.

IF it is the case that I MUST uninstall and then reinstall, are there any caveats.

I saw one post in google from someone who lost his password, and had all sorts of hassels uninstalling and reinstalling.  

Also, if it is the case that I must reinstall, should I use the install download that I still have from 2 years ago.   I remember going through SHEAR TORTURE plowing through all the websites, with all the obscure technical jargon, to find the proper windows install to download.  Perhaps things have improved in two years.  The MySQL install was effortless, up and working in 30 minutes, with no reference to instructions or help.

Anyway, I would appreciate your advice.

If you are Access users, hope you can stop by http://utteraccess.com some time and say hello.

Thanks


Want to start your own business? Learn how on Yahoo! Small Business. --0-2036407165-1165088678=:66455--