Re: pg_hba.conf - Mailing list pgsql-admin

From C. Bensend
Subject Re: pg_hba.conf
Date
Msg-id 54543.63.227.74.41.1085628969.squirrel@webmail.stinkweasel.net
Whole thread Raw
In response to Re: pg_hba.conf  (mike g <mike@thegodshalls.com>)
Responses Re: pg_hba.conf  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
> I had setup my pg_hba.conf originally like this:
>
> host   all     all     10.15.0.0       255.255.255.0   trust
>
>
> I was under the impression that the .0 was supposed to be equivalent to
> a wildcard entry so that any connection from 10.15 would be able to
> connect.  This was not so.  By changing my pg_hba.conf to this:
>
> host   all     all    10.15.13.0      255.255.255.0    trust
>
> I was able to connect successfully.  The .0 works as a wildcard entry
> for the last part but not the one prior.

Yes, when your subnet mask is set for a /24, that's correct.

Your first attempt above allowed connections for anything in the
10.15.0/24 subnet (which 10.15.13 is not a part of).

Benny


--
"Oh, the Jedis are going to feel this one!"       -- Professor Farnsworth,
                                                     "Futurama"

pgsql-admin by date:

Previous
From: mike g
Date:
Subject: Re: pg_hba.conf
Next
From: Laurens Wagemakers
Date:
Subject: Re: PG_DUMP / PG_RESTORE