[GENERAL] postgres password change

[akp geek]

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