The following bug has been logged online:
Bug reference: 5144
Logged by: George Francis
Email address: gf@liquidpoint.com
PostgreSQL version: 8.3
Operating system: Windows 2000
Description: Issue changing password
Details:
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?