Go to the
<PostgreSQL-Installation-folder>\data
and there open the pg_hba.conf file.
Now change the lines
host all all
127.0.0.1/32 md5
to
host all all
127.0.0.1/32 trust
That will allow you to login to the database without specifying the password locally.
/Shoaib
On 4/15/06, none <brooks.glenn@comcast.net> wrote: Hello, I just installed 8.1.3, for the first time on an XP machine, and
immediately had a superuser password problem, so decided to uninstall
and reinstall. However now, with the reinstall, I can't get access to
the db. pgadminIII superuser password request returns the fatal error:
" password for authenticataion failed for user postgres" message. Also
neither the original password or my 'new' password works with psql
command line prompt. So I seem to be stuck... and can't get into the
database.
Can anyone say how to properly reset the authentication password, or
baring that, how to kill the residual password file lurking about on my
machine, so I can do a fresh reinstall?
Thanks much.
Glenn Brooks
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster