Re: pg_hba.conf - Mailing list pgsql-general

From Tom Lane
Subject Re: pg_hba.conf
Date
Msg-id 17681.1163982519@sss.pgh.pa.us
Whole thread Raw
In response to pg_hba.conf  (Tom Allison <tom@tacocat.net>)
Responses Re: pg_hba.conf  (Tom Allison <tom@tacocat.net>)
List pgsql-general
Tom Allison <tom@tacocat.net> writes:
> host       all    all    127.0.0.1/32     md5
> hostssl    all    all    192.168.0.1/24   md5
                           ^^^^^^^^^^^^^^

That needs to be 192.168.0.0/24 ... as is, it won't match anything.

> But I have a localhost client that can't log in because it keeps trying to
> authenticate via SSL.

That seems unrelated --- your first line should match any local-loopback
connection, regardless of SSL or not.

            regards, tom lane

pgsql-general by date:

Previous
From: Russell Smith
Date:
Subject: Re: pg_hba.conf
Next
From: Tom Allison
Date:
Subject: Re: pg_hba.conf