Обсуждение: Forgot Password

Поиск
Список
Период
Сортировка

Forgot Password

От
Laura Briones
Дата:
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. 

V/r,

Laura Briones
Вложения

Re: Forgot Password

От
Laurenz Albe
Дата:
On Thu, 2025-09-11 at 11:49 +0400, Laura Briones wrote:
> [image of pgAdmin 4 asking for the password of "postgres"]
> 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.

Then you cannot reset the password.

You have to ask the database administrator (the person who has access to
the database server machine and can modify the configuration files)
to help you.

- a superuser can reset your password (if necessary, by starting the
  server in single-user mode)

- anybody who can modify "pg_hba.conf" can allow you to login
  without a password

Yours,
Laurenz Albe

Re: Forgot Password

От
Álvaro Herrera
Дата:
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)

Re: Forgot Password

От
Justin
Дата:
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 <alvherre@kurilemu.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 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)