| 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 |
| Message-ID: | 2935.1256756441@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| 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 127.0.0.1 to say
"trust", instead. Otherwise it sounds like you are going at it the
right way.
regards, tom lane
| 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 |