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 >
