Re: postgres password change

I don't have the root privileges. But I have followed the instructions
http://www.depesz.com/index.php/2008/11/28/recovering-lost-postgresql-password/
it worked out well.

Thanks for the suggestion

Regards

On Thu, Feb 25, 2010 at 10:21 AM, paragasu <paragasu(at)gmail(dot)com> wrote:

> 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
>>
>
>