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 ....
From: Jeff Frost [mailto:jeff(at)frostconsultingllc(dot)com]
Sent: Friday, May 16, 2008 11:38 AM
To: LaRue, Patricia
Subject: Re: [ADMIN] Can't reinstall b/c don't know the very long
On Fri, 16 May 2008, LaRue, Patricia wrote:
> I installed PostgreSQL and created the initial "very long" password
> wrote it down. Someone else did something to change it and now
> 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
you're connecting, reload postgresql, then use ALTER ROLE to set the
back to something you know. Finally, change you pg_hba.conf back to its
previous value then reload postgresql again.
Jeff Frost, Owner <jeff(at)frostconsultingllc(dot)com>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954
In response to
pgsql-admin by date
|Next:||From: Scott Marlowe||Date: 2008-05-16 20:14:14|
|Subject: Re: Can't reinstall b/c don't know the very long installation password|
|Previous:||From: Roberto Edwins||Date: 2008-05-16 17:50:28|
|Subject: Setting up of a large database|