Re: Question on MD5 authentication - Mailing list pgsql-general

From Tom Lane
Subject Re: Question on MD5 authentication
Date
Msg-id 18519.1160682640@sss.pgh.pa.us
Whole thread Raw
In response to Question on MD5 authentication  (Wei Weng <wweng@kencast.com>)
Responses Re: Question on MD5 authentication  (Wei Weng <wweng@kencast.com>)
Re: Question on MD5 authentication  (Wei Weng <wweng@kencast.com>)
List pgsql-general
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?

            regards, tom lane

pgsql-general by date:

Previous
From: Wei Weng
Date:
Subject: Re: Question on MD5 authentication
Next
From: "Germán Hüttemann Arza"
Date:
Subject: Error handling inside PL/pgSQL functions