Recover Lost Postgres Password

[Ill3git]

I can't remember my Postgres password. Is there anyway I can find out what it is?

[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