Re: postgres password change
| От | akp geek |
|---|---|
| Тема | Re: postgres password change |
| Дата | |
| Msg-id | 2024a9fb1002250747r5498c874ic603ec89bcf7fef3@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: postgres password change (paragasu <paragasu@gmail.com>) |
| Список | 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.
it worked out well.
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 doOn 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 по дате отправления: