Re: Forgotten Password

From: Raymond O'Donnell <rod(at)iol(dot)ie>
To: hunwei lee <leehunwei(at)gmail(dot)com>
Cc: pgadmin-support(at)postgresql(dot)org
Subject: Re: Forgotten Password
Date: 2010-01-15 10:52:41
Message-ID: 4B5048F9.4050807@iol.ie
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

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(at)iol(dot)ie

In response to

Browse pgadmin-support by date

  From Date Subject
Next Message Mark Cotner 2010-01-15 21:14:19 PgAdmin3 on Mac OS X Observations
Previous Message Windows 7 Compatibility 2010-01-15 07:17:46 Application compatibility with Windows7