pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedCan't reinstall b/c don't know the very long installation password
6+ messages / 4 participants
[nested] [flat]
* Can't reinstall b/c don't know the very long installation password
@ 2008-05-16 14:41 LaRue, Patricia <Patricia.LaRue@avocent.com>
0 siblings, 2 replies; 6+ messages in thread
From: LaRue, Patricia @ 2008-05-16 14:41 UTC (permalink / raw)
To: pgsql-admin
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
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Can't reinstall b/c don't know the very long installation password
@ 2008-05-16 16:38 Jeff Frost <jeff@frostconsultingllc.com>
parent: LaRue, Patricia <Patricia.LaRue@avocent.com>
1 sibling, 1 reply; 6+ messages in thread
From: Jeff Frost @ 2008-05-16 16:38 UTC (permalink / raw)
To: LaRue, Patricia <Patricia.LaRue@avocent.com>; +Cc: pgsql-admin
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
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Can't reinstall b/c don't know the very long installation password
@ 2008-05-16 17:01 Scott Marlowe <scott.marlowe@gmail.com>
parent: LaRue, Patricia <Patricia.LaRue@avocent.com>
1 sibling, 1 reply; 6+ messages in thread
From: Scott Marlowe @ 2008-05-16 17:01 UTC (permalink / raw)
To: LaRue, Patricia <Patricia.LaRue@avocent.com>; +Cc: pgsql-admin
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.
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Can't reinstall b/c don't know the very long installation password
@ 2008-05-16 17:53 LaRue, Patricia <Patricia.LaRue@avocent.com>
parent: Jeff Frost <jeff@frostconsultingllc.com>
0 siblings, 1 reply; 6+ messages in thread
From: LaRue, Patricia @ 2008-05-16 17:53 UTC (permalink / raw)
To: pgsql-admin
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
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Can't reinstall b/c don't know the very long installation password
@ 2008-05-16 20:14 Scott Marlowe <scott.marlowe@gmail.com>
parent: LaRue, Patricia <Patricia.LaRue@avocent.com>
0 siblings, 0 replies; 6+ messages in thread
From: Scott Marlowe @ 2008-05-16 20:14 UTC (permalink / raw)
To: LaRue, Patricia <Patricia.LaRue@avocent.com>; +Cc: pgsql-admin
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.
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Can't reinstall b/c don't know the very long installation password
@ 2008-05-16 20:20 Derek Hopkins <derek.hopkins@nisc.coop>
parent: Scott Marlowe <scott.marlowe@gmail.com>
0 siblings, 0 replies; 6+ messages in thread
From: Derek Hopkins @ 2008-05-16 20:20 UTC (permalink / raw)
To: Scott Marlowe <scott.marlowe@gmail.com>; LaRue, Patricia <Patricia.LaRue@avocent.com>; +Cc: pgsql-admin
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.
^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~2008-05-16 20:20 UTC | newest]
Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-05-16 14:41 Can't reinstall b/c don't know the very long installation password LaRue, Patricia <Patricia.LaRue@avocent.com>
2008-05-16 16:38 ` Jeff Frost <jeff@frostconsultingllc.com>
2008-05-16 17:53 ` LaRue, Patricia <Patricia.LaRue@avocent.com>
2008-05-16 20:14 ` Scott Marlowe <scott.marlowe@gmail.com>
2008-05-16 17:01 ` Scott Marlowe <scott.marlowe@gmail.com>
2008-05-16 20:20 ` Derek Hopkins <derek.hopkins@nisc.coop>
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