public inbox for [email protected]
help / color / mirror / Atom feedForgot Password
4+ messages / 4 participants
[nested] [flat]
* Forgot Password
@ 2025-09-11 07:49 Laura Briones <[email protected]>
2025-09-11 14:57 ` Re: Forgot Password Laurenz Albe <[email protected]>
2025-09-11 16:54 ` Re: Forgot Password Álvaro Herrera <[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 07:49 Forgot Password Laura Briones <[email protected]>
@ 2025-09-11 14:57 ` Laurenz Albe <[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 07:49 Forgot Password Laura Briones <[email protected]>
@ 2025-09-11 16:54 ` Álvaro Herrera <[email protected]>
2025-09-11 17:45 ` Re: Forgot Password Justin <[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 07:49 Forgot Password Laura Briones <[email protected]>
2025-09-11 16:54 ` Re: Forgot Password Álvaro Herrera <[email protected]>
@ 2025-09-11 17:45 ` Justin <[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