Обсуждение: Can't reinstall b/c don't know the very long installation password
Experts:
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?
Thank you,
Patricia
Patricia D. LaRue
Sr. Software Engineer, Avocent Corporation
(256) 864-2275 ext. 6543
patricia.larue@avocent.com
On Fri, May 16, 2008 at 8:41 AM, LaRue, Patricia <Patricia.LaRue@avocent.com> wrote: > Experts: > > > > 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? Two ways to do this. 1: log in in single user mode. To do so, shut down the db, then use the postgres command to bring up the db in single user mode, like so: postgres -D /my/data/dir --single and then issue the command to change the password. OR 2: change pg_hba.conf to trust on some known IP, hup the server (pg_ctl -D /my/data/dir reload) and then log in as postgres and change your 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@frostconsultingllc.com> Frost Consulting, LLC http://www.frostconsultingllc.com/ Phone: 650-780-7908 FAX: 650-649-1954
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@frostconsultingllc.com] Sent: Friday, May 16, 2008 11:38 AM To: LaRue, Patricia Cc: pgsql-admin@postgresql.org 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@frostconsultingllc.com> Frost Consulting, LLC http://www.frostconsultingllc.com/ Phone: 650-780-7908 FAX: 650-649-1954
On Fri, May 16, 2008 at 11:53 AM, LaRue, Patricia <Patricia.LaRue@avocent.com> wrote: > 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. OH! You were talking about the windows password for the postgres user. Yeah, that's the right thing to do. Sorry for the misunderstanding there.
You can also go into the pg_hba.conf file, and at the bottom put a # sign in front of host and then instead of the method set to 'md5', put 'trust'. This will allow you to login without a password, and then you can reset it. -----Original Message----- From: Scott Marlowe [mailto:scott.marlowe@gmail.com] Sent: Friday, May 16, 2008 12:02 PM To: LaRue, Patricia Cc: pgsql-admin@postgresql.org Subject: Re: Can't reinstall b/c don't know the very long installation password On Fri, May 16, 2008 at 8:41 AM, LaRue, Patricia <Patricia.LaRue@avocent.com> wrote: > Experts: > > > > 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? Two ways to do this. 1: log in in single user mode. To do so, shut down the db, then use the postgres command to bring up the db in single user mode, like so: postgres -D /my/data/dir --single and then issue the command to change the password. OR 2: change pg_hba.conf to trust on some known IP, hup the server (pg_ctl -D /my/data/dir reload) and then log in as postgres and change your password.