Re: pg_hba.conf: 'trust' vs. 'md5' Issues - Mailing list pgsql-admin

From Tom Lane
Subject Re: pg_hba.conf: 'trust' vs. 'md5' Issues
Date
Msg-id 26939.1159288367@sss.pgh.pa.us
Whole thread Raw
In response to Re: pg_hba.conf: 'trust' vs. 'md5' Issues  (Jeff Frost <jeff@frostconsultingllc.com>)
Responses Re: pg_hba.conf: 'trust' vs. 'md5' Issues  (Jeff Frost <jeff@frostconsultingllc.com>)
List pgsql-admin
Jeff Frost <jeff@frostconsultingllc.com> writes:
> Interestingly, I receive the same error when I disable SSL on the server:

If SSL is disabled then hostssl lines in pg_hba.conf effectively become
no-ops --- they can never be matched since no incoming connection will
be SSL-ified.  So that part of it sounds reasonable to me.  (Perhaps we
could log some kind of complaint in this case, though the easy places
to put in such a message would generate an unacceptably large number of
repetitions of the message :-()

> But, when I put the trust line back with hostssl, I do not get connected as
> per her original indication.

Please be clearer about what you mean here --- Jeanna *was* able to
connect in this case, if I'm not totally confused.

            regards, tom lane

pgsql-admin by date:

Previous
From: Jeff Frost
Date:
Subject: Re: pg_hba.conf: 'trust' vs. 'md5' Issues
Next
From: Jeff Frost
Date:
Subject: Re: pg_hba.conf: 'trust' vs. 'md5' Issues