Re: Install password not recognized

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(dot)glenn(at)comcast(dot)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
>