Lost postgres password

How do I recover a lost postgres superuser password or set a new one?

Hi Jemmy,

You can connect to the server by changing the authentication method to trust in pg_hba.conf file. Once connected change your password from within psql. Revert back the authentication method if required.

Regards,
Muhammad Farrukh

That works. Thanks.
I had tried a tip that said to put "local all all trust" at the top of pg_hba.conf, which did not work. The existing lines at the end of the file seemed to override it. Just changing the authentication in the existing lines from "md5" to "trust" was all I needed to do.

This message was edited 1 time. Last update was at 13 Mar 2010 08:35:09

Hi

I can`t setup postgresql-8.4.2-1windows because password is inccorect and i don`t know password...

please help

13/03/2010 07:53:29 Subject: Lost postgres password
Hi

I can`t setup postgresql-8.4.2-1windows because password is inccorect and i don`t know password...

please help

First -- You should start a new topic for this... people will find your question more easily that way.

Second, try going into the windows user manager and resetting the 'postgres' user's password from there. Then, when you run the installer enter that password