Re: Question on MD5 authentication

On Thu, 2006-10-12 at 15:50 -0400, Tom Lane wrote:
> Wei Weng <wweng(at)kencast(dot)com> writes:
> > I have the following lines in my pg_hba.conf file.
> > host all all 192.168.1.180 255.255.255.1 md5
>
> Not relevant to your immediate problem, but: you almost certainly
> want 255.255.255.255 as the netmask here.
>
> > psql -h 192.168.1.155 -U test_user template1
> > Password for user test_user: (I typed test_passwd)
> > psql: FATAL: password authentication failed for user "test_user"
>
> Did you look in the postmaster log to see if there were any more
> details?
>

Here is the relevant information in my postmaster-Thu.log.

FATAL: password authentication failed for user "test_user"

Doesn't say much.

Thanks.

Wei