Re: Fwd: resetting superuser password - Mailing list pgsql-admin

From mad
Subject Re: Fwd: resetting superuser password
Date
Msg-id 1131558609.146035.262450@g44g2000cwa.googlegroups.com
Whole thread Raw
In response to Re: Fwd: resetting superuser password  (Devrim GUNDUZ <devrim@gunduz.org>)
List 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


pgsql-admin by date:

Previous
From: "Jim C. Nasby"
Date:
Subject: Re: Xeon vs Opteron - tests and questions
Next
From: Marcin Giedz
Date:
Subject: Re: Xeon vs Opteron - tests and questions