Postgres Pro
Downloads
Home   >   mailing lists

Re: Forgot Root Password - Mailing list pgsql-admin

From Ray Stell
Subject Re: Forgot Root Password
Date
Msg-id 20080426123413.GA4035@cns.vt.edu
Whole thread Raw
In response to Forgot Root Password  ("Kranti K K Parisa™" <kranti.parisa@gmail.com>)
Responses Re: Forgot Root Password  (Craig McElroy <craig.mcelroy@contegix.com>)
Re: Forgot Root Password  ("Joshua D. Drake" <jd@commandprompt.com>)
Re: Forgot Root Password  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
Tree view 
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
this:

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
users.

pgsql-admin by date:

Previous
From: "Kranti K K Parisa™"
Date:
Subject: Forgot Root Password
Next
From: "Eric Comeau"
Date:
Subject: Re: Vacuumdb error - corruption