Many thanks. That helped.
-----Original Message-----
From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
Sent: Wednesday, October 28, 2009 2:01 PM
To: Francis, George
Cc: pgsql-bugs@postgresql.org
Subject: Re: [BUGS] BUG #5144: Issue changing password
"George Francis" <gf@liquidpoint.com> writes:
> I am trying to recover my lost password for my SU account and am having
> trouble.
> I edited the pg_hba.conf file and added the line "local all all trust".
> I then stopped and restarted the service and still get prompted to login
> when entering psql.
> How can I do this so that I can change my password for the "postgres" use=
r?
This is not a bug, and there are more appropriate forums for asking for
this type of help. However ... the problem with adding an entry for
"local" is that it's for Unix-socket connections, and there's no such
thing on Windows. You need to adjust the entry for 127.0.0.1 to say
"trust", instead. Otherwise it sounds like you are going at it the
right way.
regards, tom lane
The information in this message, including any attachment, is confidential =
and intended for use only by the designated recipient(s) named above. It is=
the property of BNY ConvergEx Group, LLC or its affiliates. If you are not=
the intended recipient, please return the message to the sender and delete=
all copies of it, including attachments, from your computer. Unauthorized =
use, disclosure, dissemination or copying of this message or any part hereo=
f is strictly prohibited. This message is for information purposes only, is=
not intended to provide a sufficient basis on which to make an investment =
decision and should not be regarded as an offer to sell or a solicitation o=
f an offer to buy any financial product. The information expressed herein m=
ay be changed at any time without notice or obligation to update. Email tra=
nsmission cannot be guaranteed to be secure, virus-free or error-free. Ther=
efore, we do not represent that this message is virus-free, complete or acc=
urate and it should not be relied upon as such. BNY ConvergEx Group, LLC an=
d its affiliates accept no liability for any damage sustained in connection=
with the content or transmission of this message.