Thank you Jeff and Scott: I found this on the archives.postgresql.org site and it worked. I wanted to post it in case someone else has the same problem. First go to start>>settings>>control panel>>user account>> select advanced tab, click advanced button>>then click user folder and delete the postgres user. Restart the installation .... Thanks again, Patricia -----Original Message----- From: Jeff Frost [mailto:jeff@xxxxxxxxxxxxxxxxxxxxxx] Sent: Friday, May 16, 2008 11:38 AM To: LaRue, Patricia Cc: pgsql-admin@xxxxxxxxxxxxxx Subject: Re: [ADMIN] Can't reinstall b/c don't know the very long installation password On Fri, 16 May 2008, LaRue, Patricia wrote: > I installed PostgreSQL and created the initial "very long" password and > wrote it down. Someone else did something to change it and now neither > one of us can log into the DB. So I tried to uninstall and reinstall > but my "very long" password is not recognized and without it I cannot > complete the installation. I even tried removing all PostgreSQL stuff > from the registry. Does anyone know how I can blow away wherever that > password is located and start fresh? Easiest thing is to change your pg_hba.conf to trust for the host from which you're connecting, reload postgresql, then use ALTER ROLE to set the password back to something you know. Finally, change you pg_hba.conf back to its previous value then reload postgresql again. -- Jeff Frost, Owner <jeff@xxxxxxxxxxxxxxxxxxxxxx> Frost Consulting, LLC http://www.frostconsultingllc.com/ Phone: 650-780-7908 FAX: 650-649-1954
