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 <parag...@gmail.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 <akpg...@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 >> > >
