Ray Stell wrote:
> On Sat, Apr 26, 2008 at 11:00:35AM +0530, Kranti K K Parisa? wrote:
>> Can anyone suggest a way to retrieve/update the postgres root password ?
> edit pg_hba.conf so that localhost connections from localhost are trusted maybe like
> host all all 127.0.0.1/32 trust
> you have to restart, but then you can do an alter user and so can all the other local
You do not need to restart, just reload.
pg_ctl -D data reload
Joshua D. Drake
In response to
pgsql-admin by date
|Next:||From: Tom Lane||Date: 2008-04-26 17:21:42|
|Subject: Re: Forgot Root Password |
|Previous:||From: Craig McElroy||Date: 2008-04-26 12:56:30|
|Subject: Re: Forgot Root Password|