Postgres Pro
Downloads
Home   >   mailing lists

Re: postgres password change - Mailing list pgsql-general

From akp geek
Subject Re: postgres password change
Date
Msg-id 2024a9fb1002250747r5498c874ic603ec89bcf7fef3@mail.gmail.com
Whole thread Raw
In response to Re: postgres password change  (paragasu <paragasu@gmail.com>)
List pgsql-general
Tree view
I don't have the root privileges. But I have followed the  instructions
 
Thanks for the suggestion
 
Regards

On Thu, Feb 25, 2010 at 10:21 AM, paragasu <paragasu@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 <akpgeek@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


pgsql-general by date:

Previous
From: akp geek
Date:
Subject: Re: postgres password change
Next
From: Alex Hunsaker
Date:
Subject: Re: Restricting the CREATEROLE privilege