Re: Question on MD5 authentication

On Thu, 2006-10-12 at 15:50 -0400, Tom Lane wrote:
> Wei Weng <wweng@kencast.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