MIME-Version: 1.0
References: <DM8PR02MB79426EC52D426F6E42B33757BA112@DM8PR02MB7942.namprd02.prod.outlook.com>
In-Reply-To: <DM8PR02MB79426EC52D426F6E42B33757BA112@DM8PR02MB7942.namprd02.prod.outlook.com>
From: Hans Schou <hans.schou@gmail.com>
Date: Tue, 23 Apr 2024 14:18:43 +0200
Message-ID: <CAApBw36c+uKOcSeqz4wLYDU7d+VKv0DcXwMO+VQ3KTWLA79PFw@mail.gmail.com>
Subject: Re: Password forgotten
To: Arbol One <ArbolOne@hotmail.ca>
Cc: pgsql-general@lists.postgresql.org
Content-Type: multipart/alternative; boundary="00000000000038bc280616c291e2"
Archived-At: <https://www.postgresql.org/message-id/CAApBw36c%2BuKOcSeqz4wLYDU7d%2BVKv0DcXwMO%2BVQ3KTWLA79PFw%40mail.gmail.com>
Precedence: bulk

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

Have you tried

   sudo -u postgres psql


On Tue, Apr 23, 2024 at 2:14=E2=80=AFPM Arbol One <ArbolOne@hotmail.ca> wro=
te:

> 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?
>
> Thanks in advance.
>
>
> --
> *ArbolOne.ca* Using Fire Fox and Thunderbird. ArbolOne is composed of
> students and volunteers dedicated to providing free services to charitabl=
e
> organizations. ArbolOne on Java Development is in progress [ =C3=AD ]
>


--=20
=F0=9D=95=B3=F0=9D=96=86=F0=9D=96=93=F0=9D=96=98 =F0=9D=95=BE=F0=9D=96=88=
=F0=9D=96=8D=F0=9D=96=94=F0=9D=96=9A
=E2=98=8F =E2=9E=81=E2=9E=81 =E2=9E=85=E2=9E=83 =E2=9E=87=E2=93=AA =E2=9E=
=81=E2=93=AA

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

<div dir=3D"ltr"><div><br></div><div>Have you tried</div><div><br></div><di=
v>=C2=A0=C2=A0 sudo -u postgres psql</div><div><br></div></div><br><div cla=
ss=3D"gmail_quote"><div dir=3D"ltr" class=3D"gmail_attr">On Tue, Apr 23, 20=
24 at 2:14=E2=80=AFPM Arbol One &lt;<a href=3D"mailto:ArbolOne@hotmail.ca">=
ArbolOne@hotmail.ca</a>&gt; wrote:<br></div><blockquote class=3D"gmail_quot=
e" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204)=
;padding-left: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?<br>
      <br>
      Thanks in advance.<br>
    </p>
    <p><br>
    </p>
    <div>-- <br>
      <b><i>ArbolOne.ca</i></b>
      Using Fire Fox and Thunderbird.
      ArbolOne is composed of students and volunteers dedicated to
      providing free services to charitable organizations.
      ArbolOne on Java Development is in progress [ =C3=AD ]</div>
  </div>
  <u></u><u></u>

</blockquote></div><br clear=3D"all"><br><span class=3D"gmail_signature_pre=
fix">-- </span><br><div dir=3D"ltr" class=3D"gmail_signature"><div dir=3D"l=
tr"><div><div dir=3D"ltr"><div>=F0=9D=95=B3=F0=9D=96=86=F0=9D=96=93=F0=9D=
=96=98=C2=A0=F0=9D=95=BE=F0=9D=96=88=F0=9D=96=8D=F0=9D=96=94=F0=9D=96=9A<br=
></div><div>=E2=98=8F =E2=9E=81=E2=9E=81 =E2=9E=85=E2=9E=83 =E2=9E=87=E2=93=
=AA =E2=9E=81=E2=93=AA<br></div></div></div></div></div>

--00000000000038bc280616c291e2--