Обсуждение: 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.

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.