Lists: | pgsql-general |
---|
From: | akp geek <akpgeek(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | postgres password change |
Date: | 2010-02-25 15:15:55 |
Message-ID: | 2024a9fb1002250715m1a0bc25h585ac7c762818b24@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-general |
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
From: | hubert depesz lubaczewski <depesz(at)depesz(dot)com> |
---|---|
To: | akp geek <akpgeek(at)gmail(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: postgres password change |
Date: | 2010-02-25 15:18:55 |
Message-ID: | 20100225151854.GA21362@depesz.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-general |
On Thu, Feb 25, 2010 at 10:15:55AM -0500, akp geek 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?
http://www.depesz.com/index.php/2008/11/28/recovering-lost-postgresql-password/
depesz
--
Linkedin: http://www.linkedin.com/in/depesz / blog: http://www.depesz.com/
jid/gtalk: depesz(at)depesz(dot)com / aim:depeszhdl / skype:depesz_hdl / gg:6749007
From: | paragasu <paragasu(at)gmail(dot)com> |
---|---|
To: | akp geek <akpgeek(at)gmail(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: postgres password change |
Date: | 2010-02-25 15:21:21 |
Message-ID: | 89b35b8d1002250721g3c1c3f0ao260b74d03aec00a8@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-general |
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
>
From: | akp geek <akpgeek(at)gmail(dot)com> |
---|---|
To: | depesz(at)depesz(dot)com |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: postgres password change |
Date: | 2010-02-25 15:46:27 |
Message-ID: | 2024a9fb1002250746k402e234aj6e09d186d2ae6f24@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-general |
Thank you. It worked
Regards
On Thu, Feb 25, 2010 at 10:18 AM, hubert depesz lubaczewski <
depesz(at)depesz(dot)com> wrote:
> On Thu, Feb 25, 2010 at 10:15:55AM -0500, akp geek 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?
>
>
> http://www.depesz.com/index.php/2008/11/28/recovering-lost-postgresql-password/
>
> depesz
>
> --
> Linkedin: http://www.linkedin.com/in/depesz / blog:
> http://www.depesz.com/
> jid/gtalk: depesz(at)depesz(dot)com / aim:depeszhdl / skype:depesz_hdl /
> gg:6749007
>
From: | akp geek <akpgeek(at)gmail(dot)com> |
---|---|
To: | paragasu <paragasu(at)gmail(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: postgres password change |
Date: | 2010-02-25 15:47:47 |
Message-ID: | 2024a9fb1002250747r5498c874ic603ec89bcf7fef3@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-general |
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
>>
>
>