pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Scott Marlowe <scott.marlowe@gmail.com>
To: LaRue, Patricia <Patricia.LaRue@avocent.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Can't reinstall b/c don't know the very long installation password
Date: Fri, 16 May 2008 11:01:30 -0600
Message-ID: <dcc563d10805161001p26d527ccwb763848f0e122ec0@mail.gmail.com> (raw)
In-Reply-To: <DCA754113E788947A6111339A0470225FA1E0C@hsv-email2.corp.avocent.com>
References: <DCA754113E788947A6111339A0470225FA1E0C@hsv-email2.corp.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.



view thread (6+ messages)  latest in thread

Message-ID: <dcc563d10805161001p26d527ccwb763848f0e122ec0@mail.gmail.com>
Permalink:  ../dcc563d10805161001p26d527ccwb763848f0e122ec0@mail.gmail.com/
Also on:    postgresql.org/message-id/dcc563d10805161001p26d527ccwb763848f0e122ec0@mail.gmail.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: scott.marlowe@gmail.com, Patricia.LaRue@avocent.com
  Subject: Re: Can't reinstall b/c don't know the very long installation password
  In-Reply-To: <dcc563d10805161001p26d527ccwb763848f0e122ec0@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

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