Yes, that was a typo on my part. I also found out that the MASK should
be 255.255.255.255 if I want only the single system to access my
database... But that did not fix the problem either.
Any more suggestions would be appriciated!
Doug
Tom Lane wrote:
> Doug Thistlethwaite <doug.t@deltanet.com> writes:
> > Password authentication failed for user 'doug'
> >
> > Does anybody have an idea of what I can try to get this working?
>
> This tells you you are getting pretty far: you are making a TCP
> connection, and the postmaster is recognizing that the entry for
> your IP address in pg_hba demands password authentication. So,
> either you are supplying the wrong password from the client end,
> or something's wrong with the password file.
>
> There might be more info in the postmaster log file than is reported
> to the client --- did you look there?
>
> One potential typo stands out in your message:
>
> > The password file was created using the command pg_passwd
> > /var/postgresql/passwd
> ^^^^^^^^^^
> > host doug IP.ADDRESS.OF PC 255.255.255.0 password
> > /var/postgres/passwd
> ^^^^^^^^
>
> Prolly that's just a transcription error in your message, but if
> it's real...
>
> regards, tom lane