MIME-Version: 1.0
References: 
 <CANzdf-ZQ5CGxtP-A8ZMnQdhrPKK3nXLqqzbYL5U4DsEv=oQsiQ@mail.gmail.com>
 <202509111457.7uj26nyvbu5n@alvherre.pgsql>
In-Reply-To: <202509111457.7uj26nyvbu5n@alvherre.pgsql>
From: Justin <zzzzz.graf@gmail.com>
Date: Thu, 11 Sep 2025 13:45:51 -0400
Message-ID: 
 <CALL-XePEVZq4LtoGpx2vrCTXPfx0+Wy+cNkpWYCUy0SU2HE2yQ@mail.gmail.com>
Subject: Re: Forgot Password
To: =?UTF-8?Q?=C3=81lvaro_Herrera?= <alvherre@kurilemu.de>
Cc: Laura Briones <laura.aylin.13@gmail.com>,
 pgsql-novice@lists.postgresql.org
Content-Type: multipart/alternative; boundary="000000000000598ed5063e8a1c39"
Archived-At: 
 <https://www.postgresql.org/message-id/CALL-XePEVZq4LtoGpx2vrCTXPfx0%2BWy%2BcNkpWYCUy0SU2HE2yQ%40mail.gmail.com>
Precedence: bulk

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

There is no way to reset the password without logging into the host
resetting the password  if there is no other superuser or other high
level role to login as..

If this is a Linux box sudo as postgres then psql  the default
configuration is trust Unix Sockets,  then can reset the password.
have to have sudo powers to become postgres...  have to have sudo powers to
modify the pg_hba.conf file  then reload the config..

sudo -iu postgres
psql
\password <username>

Windows this is bit harder,  best add localhost trust entry into the
pg_hba.conf  then reload the configuration

psql -h localhost -U postgres  -d postgres
\password <username>

Hope this helps

Thanks
Justin


On Thu, Sep 11, 2025 at 1:30=E2=80=AFPM =C3=81lvaro Herrera <alvherre@kuril=
emu.de> wrote:

> On 2025-Sep-11, Laura Briones wrote:
>
> > [image: image.png]
> > Hi, How do I reset this password? The data file is not on my computer s=
o
> I
> > can't go into  pg_hba.conf to reset.
>
> I don't know of any way to reset that password without logging in to the
> computer that hosts the service.
>
> --
> =C3=81lvaro Herrera        Breisgau, Deutschland  =E2=80=94
> https://www.EnterpriseDB.com/
> "En las profundidades de nuestro inconsciente hay una obsesiva necesidad
> de un universo l=C3=B3gico y coherente. Pero el universo real se halla si=
empre
> un paso m=C3=A1s all=C3=A1 de la l=C3=B3gica" (Irulan)
>
>
>

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

<div dir=3D"ltr">There is no way to reset the password without logging into=
 the host resetting=C2=A0the password=C2=A0 if there is no=C2=A0other super=
user or other high level=C2=A0role to login as..<br><br>If this is a Linux =
box sudo as postgres then psql=C2=A0 the default configuration is trust Uni=
x Sockets,=C2=A0 then can reset the password.<br>have to have sudo powers t=
o become postgres...=C2=A0 have to have sudo powers to modify the pg_hba.co=
nf file=C2=A0 then reload the config..<br><br>sudo -iu postgres<br>psql=C2=
=A0<br>\password &lt;username&gt;=C2=A0<br><br>Windows this is bit harder,=
=C2=A0 best add localhost trust entry into the pg_hba.conf=C2=A0 then reloa=
d the configuration<br><br>psql -h localhost -U postgres=C2=A0 -d postgres<=
br>\password &lt;username&gt;<br><br>Hope this helps<br><br>Thanks<br>Justi=
n<br><br></div><br><div class=3D"gmail_quote gmail_quote_container"><div di=
r=3D"ltr" class=3D"gmail_attr">On Thu, Sep 11, 2025 at 1:30=E2=80=AFPM =C3=
=81lvaro Herrera &lt;<a href=3D"mailto:alvherre@kurilemu.de">alvherre@kuril=
emu.de</a>&gt; wrote:<br></div><blockquote class=3D"gmail_quote" style=3D"m=
argin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left=
:1ex">On 2025-Sep-11, Laura Briones wrote:<br>
<br>
&gt; [image: image.png]<br>
&gt; Hi, How do I reset this password? The data file is not on my computer =
so I<br>
&gt; can&#39;t go into=C2=A0 pg_hba.conf to reset.<br>
<br>
I don&#39;t know of any way to reset that password without logging in to th=
e<br>
computer that hosts the service.<br>
<br>
-- <br>
=C3=81lvaro Herrera=C2=A0 =C2=A0 =C2=A0 =C2=A0 Breisgau, Deutschland=C2=A0 =
=E2=80=94=C2=A0 <a href=3D"https://www.EnterpriseDB.com/" rel=3D"noreferrer=
" target=3D"_blank">https://www.EnterpriseDB.com/</a><br>
&quot;En las profundidades de nuestro inconsciente hay una obsesiva necesid=
ad<br>
de un universo l=C3=B3gico y coherente. Pero el universo real se halla siem=
pre<br>
un paso m=C3=A1s all=C3=A1 de la l=C3=B3gica&quot; (Irulan)<br>
<br>
<br>
</blockquote></div>

--000000000000598ed5063e8a1c39--