MIME-Version: 1.0
In-Reply-To: <DM8PR02MB79426EC52D426F6E42B33757BA112@DM8PR02MB7942.namprd02.prod.outlook.com>
References: <DM8PR02MB79426EC52D426F6E42B33757BA112@DM8PR02MB7942.namprd02.prod.outlook.com>
From: "David G. Johnston" <david.g.johnston@gmail.com>
Date: Tue, 23 Apr 2024 06:27:00 -0700
Message-ID: <CAKFQuwa1n3qAsZOZ6bq+3gKYC=C_BEaiV9+E4_RE=swROV147Q@mail.gmail.com>
Subject: Re: Password forgotten
To: Arbol One <ArbolOne@hotmail.ca>
Cc: "pgsql-general@lists.postgresql.org" <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="00000000000051dffb0616c382ed"
Archived-At: <https://www.postgresql.org/message-id/CAKFQuwa1n3qAsZOZ6bq%2B3gKYC%3DC_BEaiV9%2BE4_RE%3DswROV147Q%40mail.gmail.com>
Precedence: bulk

--00000000000051dffb0616c382ed
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

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 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=E2=80=99t require a pass=
word
then change the password.  See pg_hba.conf for authentication options.
Usually connecting via local and peer authentication is the default option.

David J.

--00000000000051dffb0616c382ed
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<br><br>On Tuesday, April 23, 2024, Arbol One &lt;<a href=3D"mailto:ArbolOn=
e@hotmail.ca">ArbolOne@hotmail.ca</a>&gt; wrote:<br><blockquote class=3D"gm=
ail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-le=
ft:1ex"><u></u>

 =20
  <div style=3D"padding-bottom:1px">
    <p><font face=3D"monospace">Hello.<br>
        In my Debian box, after entering this command to psql-16, <b>psql
          -h localhost -U postgres</b><br>
      </font></p>
    <p><font face=3D"monospace">psql-16 asks for the password, which I
        have forgotten. <br>
        So I get this message:</font></p>
    <p><font face=3D"monospace"><b>psql: error: connection to server at
          &quot;localhost&quot; (::1), port 5432 failed: FATAL:=C2=A0 passw=
ord
          authentication failed for user &quot;postgres&quot;<br>
          connection to server at &quot;localhost&quot; (::1), port 5432 fa=
iled:
          FATAL:=C2=A0 password authentication failed for user &quot;postgr=
es&quot;<br>
        </b></font></p>
    <p>Is there a way I can retrieve this master password?</p></div></block=
quote><div><br></div><div>Nope.=C2=A0 You need to login using a method that=
 doesn=E2=80=99t require a password then change the password.=C2=A0 See pg_=
hba.conf for authentication options.=C2=A0 Usually connecting via local and=
 peer authentication is the default option.</div><div><br></div><div>David =
J.</div>

--00000000000051dffb0616c382ed--