Re: remote connections to Windows based server - Mailing list pgsql-admin

From Tom Lane
Subject Re: remote connections to Windows based server
Date
Msg-id 22004.1163804096@sss.pgh.pa.us
Whole thread Raw
In response to Re: remote connections to Windows based server  (Jeff Frost <jeff@frostconsultingllc.com>)
Responses Re: remote connections to Windows based server  (Jeff Frost <jeff@frostconsultingllc.com>)
List pgsql-admin
Jeff Frost <jeff@frostconsultingllc.com> writes:
> I believe you must list all 4 octets of the subnet.

Oh, duh.  The comments in inet_aton() show that it is interpreting
"10.6" in what most people nowadays would find a surprising way:

        case 1:            /* a -- 32 bits */
        case 2:            /* a.b -- 8.24 bits */
        case 3:            /* a.b.c -- 8.8.16 bits */
        case 4:            /* a.b.c.d -- 8.8.8.8 bits */

ie, it is read as if it were "10.0.0.6" ... hence no match, but also no
syntax error.

            regards, tom lane

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: remote connections to Windows based server
Next
From: Jeff Frost
Date:
Subject: Re: remote connections to Windows based server