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