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  (Adrian Klaver <adrian.klaver@aklaver.com>)
Список 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 по дате отправления:

Предыдущее
От: John McKown
Дата:
Сообщение: Re: I lost my password
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: how to compile postgresql with other version of openssl?