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 [email protected] -- Sent via pgadmin-support mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
