Re: [ADMIN] Forgot Root Password

2008-04-26 Thread Tom Lane
Ray Stell <[EMAIL PROTECTED]> writes: > 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: > hostall

Re: [ADMIN] Forgot Root Password

2008-04-26 Thread Joshua D. Drake
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 this: hostall all 127.0.0.1/

Re: [ADMIN] Forgot Root Password

2008-04-26 Thread Craig McElroy
Also, if you wish to avoid a full restart of the database, this change would be picked up by a "pg_ctl reload" as well. Cheers, -craig --- Craig A. McElroy Contegix LLC Beyond Managed Hosting(r) for Your Enterprise On Apr 26, 2008, at 7:34 AM, Ray Stell wrote: On Sat, Apr 26, 2008 at 11:00:3

Re: [ADMIN] Forgot Root Password

2008-04-26 Thread Ray Stell
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: hostall all 127.0.0.1/32 trust