Re: Forgot Password - Mailing list pgsql-novice

From Laurenz Albe
Subject Re: Forgot Password
Date
Msg-id d3d6b987ff67f44a2c3659a2da3783e10065e51f.camel@cybertec.at
Whole thread Raw
In response to Forgot Password  (Laura Briones <laura.aylin.13@gmail.com>)
List pgsql-novice
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



pgsql-novice by date:

Previous
From: Laura Briones
Date:
Subject: Forgot Password
Next
From: Álvaro Herrera
Date:
Subject: Re: Forgot Password