From: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
---|---|
To: | Arbol One <ArbolOne(at)hotmail(dot)ca> |
Cc: | "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
Subject: | Re: Password forgotten |
Date: | 2024-04-23 13:27:00 |
Message-ID: | CAKFQuwa1n3qAsZOZ6bq+3gKYC=C_BEaiV9+E4_RE=swROV147Q@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Tuesday, April 23, 2024, Arbol One <ArbolOne(at)hotmail(dot)ca> wrote:
> Hello.
> In my Debian box, after entering this command to psql-16, *psql -h
> localhost -U postgres*
>
> psql-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.
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2024-04-23 14:19:17 | Re: Password forgotten |
Previous Message | Marcos Pegoraro | 2024-04-23 12:41:25 | Re: query multiple schemas |