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.
From: Scott Marlowe [mailto:scott(dot)marlowe(at)gmail(dot)com]
Sent: Friday, May 16, 2008 12:02 PM
To: LaRue, Patricia
Subject: Re: Can't reinstall b/c don't know the very long installation
On Fri, May 16, 2008 at 8:41 AM, LaRue, Patricia
> I installed PostgreSQL and created the initial "very long" password
> wrote it down. Someone else did something to change it and now
> of us can log into the DB. So I tried to uninstall and reinstall but
> "very long" password is not recognized and without it I cannot
> installation. I even tried removing all PostgreSQL stuff from the
> Does anyone know how I can blow away wherever that password is
> 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.
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
In response to
pgsql-admin by date
|Next:||From: kevin kempter||Date: 2008-05-16 21:12:02|
|Subject: Global / cluster-wide functions|
|Previous:||From: Scott Marlowe||Date: 2008-05-16 20:18:02|
|Subject: Re: Setting up of a large database|