Re: Password forgotten
| От | David G. Johnston |
|---|---|
| Тема | Re: Password forgotten |
| Дата | |
| Msg-id | CAKFQuwa1n3qAsZOZ6bq+3gKYC=C_BEaiV9+E4_RE=swROV147Q@mail.gmail.com обсуждение исходный текст |
| Ответ на | Password forgotten (Arbol One <ArbolOne@hotmail.ca>) |
| Ответы |
Re: Password forgotten
|
| Список | pgsql-general |
On Tuesday, April 23, 2024, Arbol One <ArbolOne@hotmail.ca> wrote:
Hello.
In my Debian box, after entering this command to psql-16, psql -h localhost -U postgrespsql-16 asks for the password, which I have forgotten.
So I get this message:psql: error: connection to server at "localhost" (::1), port 5432 failed: FATAL: password authentication failed for user "postgres"
connection to server at "localhost" (::1), port 5432 failed: FATAL: password authentication failed for user "postgres"Is there a way I can retrieve this master password?
Nope. You need to login using a method that doesn’t require a password then change the password. See pg_hba.conf for authentication options. Usually connecting via local and peer authentication is the default option.
David J.
В списке pgsql-general по дате отправления: