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
>
>