Page 1 of 1

Recover Lost Postgres Password

PostPosted: Fri Mar 14, 2008 11:29 pm
by Ill3git
I can't remember my Postgres password. Is there anyway I can find out what it is?

Re: Recover Lost Postgres Password

PostPosted: Sat Mar 15, 2008 12:51 am
by APerfect10
There is no way to recover it but we can tell PostgreSQL to not require a password.

Go Start->Programs->PostgreSQL->Configuration Files->Edit pg_hba.conf

At the bottom of the file there are two lines that end with 'md5'. Change 'md5' to 'trust'. File->Save

Then go Start->Programs->PostgreSQL->Reload Configurations

You can now omit the password field as it is not required.

Best regards,

Derek

highfalutin