Re: I lost my password
От | |
---|---|
Тема | Re: I lost my password |
Дата | |
Msg-id | 15D7C240F4EF40218E06FB51E2E470EC@ArbolOnePC обсуждение исходный текст |
Ответ на | Re: I lost my password (Adrian Klaver <adrian.klaver@aklaver.com>) |
Ответы |
Re: I lost my password
|
Список | pgsql-general |
I am using windows 8.1 and what I believe to be the latest version of posgresql from postgresql.org. Would it be better to reinstall postgresql? -----Original Message----- From: Adrian Klaver Sent: Sunday, July 26, 2015 11:01 PM To: papa@arbolone.ca ; PostGreSQL MailingList Subject: Re: [GENERAL] I lost my password On 07/26/2015 07:51 PM, papa@arbolone.ca wrote: > After installing PostgreSQL I lost the password, how can I recover it? What OS? How did you install? What password are you talking about? Assuming you are talking about a Postgres password, take a look at: http://www.postgresql.org/docs/9.4/interactive/auth-pg-hba-conf.html From there you can set the local connection to trust and then access Postgres. From there you can reset the password using ALTER USER: http://www.postgresql.org/docs/9.4/interactive/sql-alteruser.html -- Adrian Klaver adrian.klaver@aklaver.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
В списке pgsql-general по дате отправления: