Skip site navigation (1) Skip section navigation (2)

Re: Forgot Root Password

From: Ray Stell <stellr(at)cns(dot)vt(dot)edu>
To: Kranti K K Parisa? <kranti(dot)parisa(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Forgot Root Password
Date: 2008-04-26 12:34:13
Message-ID: (view raw or whole thread)
Lists: pgsql-admin
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          trust

you have to restart, but then you can do an alter user and so can all the other local

In response to


pgsql-admin by date

Next:From: Andrew SullivanDate: 2008-04-26 12:56:09
Subject: Re: Vacuumdb error - corruption
Previous:From: Kranti K K Parisa™Date: 2008-04-26 05:30:35
Subject: Forgot Root Password

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group