Re: Fwd: resetting superuser password

From: "mad" <mad7(at)runbox(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: Fwd: resetting superuser password
Date: 2005-11-09 17:50:09
Message-ID: 1131558609.146035.262450@g44g2000cwa.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Thanks to all who replied, and all apologies for the multiple posting
(my fault).

The solution (in postgres 8.0.1):

Edit data/pg_hba.conf to contain the line:

local all postgres trust

Then su to unix user postgres and restart postges with:

> bin/pg_ctl restart -D /usr/local/pgsql/data -m fast

and finally, login to postgres with:

> psql -U postgres -d template1

and do

alter user postgres with encrypted password 'newpass';

Remove the line added to pg_hba.conf, and restart postgres again!
I'm a happy (and very relieved) camper.

Marc

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Jim C. Nasby 2005-11-09 18:15:04 Re: Xeon vs Opteron - tests and questions
Previous Message Matthew T. O'Connor 2005-11-09 16:47:26 Re: autovacuum daemon question...