public inbox for [email protected]  

help / color / mirror / Atom feed

From: Justin <[email protected]>
To: Álvaro Herrera <[email protected]>
Cc: Laura Briones <[email protected]>
Cc: [email protected]
Subject: Re: Forgot Password
Date: Thu, 11 Sep 2025 13:45:51 -0400
Message-ID: <CALL-XePEVZq4LtoGpx2vrCTXPfx0+Wy+cNkpWYCUy0SU2HE2yQ@mail.gmail.com> (raw)
In-Reply-To: <[email protected]>
References: <CANzdf-ZQ5CGxtP-A8ZMnQdhrPKK3nXLqqzbYL5U4DsEv=oQsiQ@mail.gmail.com>
	<[email protected]>

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 PM Álvaro Herrera <[email protected]> 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 so
> 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.
>
> --
> Álvaro Herrera        Breisgau, Deutschland  —
> https://www.EnterpriseDB.com/
> "En las profundidades de nuestro inconsciente hay una obsesiva necesidad
> de un universo lógico y coherente. Pero el universo real se halla siempre
> un paso más allá de la lógica" (Irulan)
>
>
>

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected], [email protected]
  Subject: Re: Forgot Password
  In-Reply-To: <CALL-XePEVZq4LtoGpx2vrCTXPfx0+Wy+cNkpWYCUy0SU2HE2yQ@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox