Thread

1. Forgot Password

   Laura Briones <laura.aylin.13@gmail.com> — 2025-09-11T07:49:49Z

   [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.
   
   V/r,
   
   Laura Briones
   

2. Re: Forgot Password

   Laurenz Albe <laurenz.albe@cybertec.at> — 2025-09-11T14:57:32Z

   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
   
   
   
   

3. Re: Forgot Password

   Álvaro Herrera <alvherre@kurilemu.de> — 2025-09-11T16:54:53Z

   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)
   
   
   
   

4. Re: Forgot Password

   Justin <zzzzz.graf@gmail.com> — 2025-09-11T17:45:51Z

   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)
   >
   >
   >