public inbox for [email protected]help / color / mirror / Atom feed
Forgot Password 4+ messages / 4 participants [nested] [flat]
* Forgot Password @ 2025-09-11 07:49 Laura Briones <[email protected]> 0 siblings, 2 replies; 4+ messages in thread From: Laura Briones @ 2025-09-11 07:49 UTC (permalink / raw) To: [email protected] [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 Attachments: [image/png] image.png (54.9K, 3-image.png) download | view image ^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Forgot Password @ 2025-09-11 14:57 Laurenz Albe <[email protected]> parent: Laura Briones <[email protected]> 1 sibling, 0 replies; 4+ messages in thread From: Laurenz Albe @ 2025-09-11 14:57 UTC (permalink / raw) To: Laura Briones <[email protected]>; [email protected] 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 ^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Forgot Password @ 2025-09-11 16:54 Álvaro Herrera <[email protected]> parent: Laura Briones <[email protected]> 1 sibling, 1 reply; 4+ messages in thread From: Álvaro Herrera @ 2025-09-11 16:54 UTC (permalink / raw) To: Laura Briones <[email protected]>; +Cc: [email protected] 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) ^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Forgot Password @ 2025-09-11 17:45 Justin <[email protected]> parent: Álvaro Herrera <[email protected]> 0 siblings, 0 replies; 4+ messages in thread From: Justin @ 2025-09-11 17:45 UTC (permalink / raw) To: Álvaro Herrera <[email protected]>; +Cc: Laura Briones <[email protected]>; [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) > > > ^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2025-09-11 17:45 UTC | newest] Thread overview: 4+ messages (download: mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2025-09-11 07:49 Forgot Password Laura Briones <[email protected]> 2025-09-11 14:57 ` Laurenz Albe <[email protected]> 2025-09-11 16:54 ` Álvaro Herrera <[email protected]> 2025-09-11 17:45 ` Justin <[email protected]>
This inbox is served by agora; see mirroring instructions for how to clone and mirror all data and code used for this inbox