| 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: | Whole Thread | Raw Message | 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
| 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 |