| 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: | Whole Thread | Raw Message | 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 |