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 r...@iol.ie -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
