An update to this thread for this issue for any future people having
the same problem
Found a fix for this. It seems that if you have the address set to
'127.0.0.1' it does not correctly use the stored password but if you
use 'localhost' it does. Very strange indeed.
On 12/9/05, Andreas Pflug <pgadmin@pse-consulting.de> wrote:
> Collin Peters wrote:
> > On 12/7/05, Andreas Pflug <pgadmin@pse-consulting.de> wrote:
> >
> >>See www.pgadmin.org
> >
> >
> > 1.5 snapshot did not work
> >
> > I un-installed 1.4 (and my old 1.2 which I thought may cause some
> > problems) and ran 1.5. Same problem.... I noticed it still remembered
> > my server info so I found a registry key (HKCU\Software\pgAdmin III)
> > deleted it and then pgadmin seemed to start up fresh (tips started
> > showing up again, etc..) I then added a new server, and it was
> > exactly like the process before. i.e. same error, etc...
> >
> >
> >>>By db/user/passwd details do you mean the contents of pgpass.conf? If
> >>>so it is
> >>>
> >>>127.0.0.1:5432:*:dbuser:dbpassword
> >
> >
> > Well... not sure what else to say :) Must be something in the OS...
> > some DLL or something. Like I said... the same setup works ok on
> > other computers.
>
> The new snapshot will log the password filename if debugging log is
> enabled; this should be consistent with what SET APPDATA returns on a
> command line. If not, let me know.
>
> In addition, you could check for other libpq.dll versions sneaking
> around on your computer; report the version you're actually using.
>
> All I can advise further is to check with psql and manually editing
> pgpass.conf, and post the difference.
>
> Regards,
> Andreas
>