Re: postgres password change

if you know the root password

#su root
#su postgres
#psql
#alter role <username> with password <password>

it think that should do

On Thu, Feb 25, 2010 at 11:15 PM, akp geek <akpgeek@gmail.com> wrote:

Dear all -

 

                     I forgot the password for the postgres user for the database. Is there way I can reset the password to whatever I want. When I do the psql -U postgres , it's prompting me the password. Can you please help?

 

 

Regards