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(at)gmail(dot)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
>