From: Philippe Salama <karebacnyc@yahoo.com>
To: pgsql-admin@postgresql.org
Subject: Lost password to user postgres
Date: Sat, 2 Dec 2006 11:44:38 -0800 (PST)
Message-ID: <638600.66455.qm@web90513.mail.mud.yahoo.com> (raw)
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: karebacnyc@yahoo.com
Subject: Re: Lost password to user postgres
In-Reply-To: <638600.66455.qm@web90513.mail.mud.yahoo.com>
References: <638600.66455.qm@web90513.mail.mud.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox