Recover Lost Postgres Password

Posted:
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

Posted:
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