Thread: Forgotten Password

Hi,<br /><br />I've trying to back up my database for PostgreSQL (i'm using it wiht Hold'em Manager) but i've forgotten
mypassword. Can i retrieve or reset the password?<br /><br />Thanks.<br /><br />Andy<br /> 

On 15/01/2010 06:12, hunwei lee wrote:
> Hi,
> 
> I've trying to back up my database for PostgreSQL (i'm using it wiht
> Hold'em Manager) but i've forgotten my password. Can i retrieve or reset
> the password?

The usual way involves editing your pg_hba.conf file:

(i) Set the authentication method for your connection to "trust"

(ii) You'll be able to log in now without a password, so connect and
reset the password.

(iii) Edit pg_hba.conf again and reset the method to "md5" or whatever
it was.

HTH,

Ray.

-- 
Raymond O'Donnell :: Galway :: Ireland
rod@iol.ie