Re: I "might" have found a bug on 8.2.1 win32

> ------- Original Message -------
> From: Tony Caduto <tony_caduto@amsoftwaredesign.com>
> To: Bill Moran <wmoran@collaborativefusion.com>
> Sent: 01/02/07, 17:13:25
> Subject: Re: [GENERAL] I "might" have found a bug on 8.2.1 win32
>
> Bill Moran wrote:
> >
> > Will only apply if you connect via loopback networking (which is not
> > psql's default).  Try your connect command like this:
> > psql template1 -U postgres -h 127.0.0.1
> > and see if the results change.
> >
> >
> Hi Bill,
>
> Using the -h 127.0.0.1 does cause the password prompt to fire, however
> the weird part is in my pg_hba.conf I also have the local entry set to md5
>
> local   all         all                               md5
>
>
> I did some more testing and it seems the password I used during the
> win32 install is being cached somewhere.
> If I don't change the password from the one I used during the install it
> lets me right in, if I change the password to something else I get a
> password
> authentication error with a blank password, if I then change the
> postgres password back to the one I used during install a blank password
> again lets me right in.   I have not done a reboot yet, I will do reboot
> and see if that clears it up.

Could this be proof of you using pgAdmin ( :-) ) and checking the Store Password option? That'll save it in pgpass.conf
inyour profile. 

/D