Re: BUG #5144: Issue changing password

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "George Francis" <gf(at)liquidpoint(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #5144: Issue changing password
Date: 2009-10-28 19:00:41
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-bugs

"George Francis" <gf(at)liquidpoint(dot)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" user?

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 to say
"trust", instead. Otherwise it sounds like you are going at it the
right way.

regards, tom lane

In response to


Browse pgsql-bugs by date

  From Date Subject
Next Message Francis, George 2009-10-28 20:01:30 Re: BUG #5144: Issue changing password
Previous Message Bernt Marius Johnsen 2009-10-28 18:53:07 BUG #5145: Complex query with lots of LEFT JOIN causes segfault