Re: Setting up security for development

Hi Michael,

  You are correct in you assesment regarding x.x.x.x/32

http://en.wikipedia.org/wiki/Classless_Inter-Domain_Routing

Best regards, Saul


Michael Swierczek wrote:
> I'm no expert, but I believe the format of your pg_hba.conf is wrong.
>
>
>>> # TYPE  DATABASE    USER        CIDR-ADDRESS          METHOD
>>>
>>> # IPv4 local connections:
>>> #host    all         all         127.0.0.1/32
>>> host    all         all         192.168.1.0/32 255.255.255.0        trust
>>> # IPv6 local connections:
>>> host    all         all         ::1/128               md5
>>>
>>>
> The error is this
> host    all         all         192.168.1.0/32 255.255.255.0        trust
>
> I think you want
> 192.168.1.0/24    OR
> 192.168.1.0 255.255.255.0
>
> I don't know if specifying both would work.
> Also /32 means that all four groups of numbers must match, so you can
> only connect from the exact IP address 192.168.1.0.
> /8  means you can connect from 192.anything
> /16 means 192.168.anything
> /24 means 192.168.1.anything
> /32 means 192.168.1.0 exact match
>
> -Mike Swierczek
>
>