The following in the pg_hba.conf file allows "some" computers on our
network to connect PostgreSQL on the machine 10.1.16.24:

host all all 10.1.16.0 255.255.255.0 trust

I want to change the configuration to allow anyone on the local area
network to connect to the machine. I've tried the following and I'm
guessing that I just don't understand the addressing correctly:

host all all 127.0.0.1/32 trust

Help?

O.B. napsal(a):
Hi,
what does it mean "local area"?

127.*.*.* is only your computer.

Trust method mean, connect without password.

--
MiLo

Begin <12lhnj83b3fmo37 (AT) corp (DOT) supernews.com>
On 2006-11-13, O.B. <funkjunk (AT) bellsouth (DOT) net> wrote:
That allows all hosts from 10.1.16.0 to 10.1.16.255[1], or in CIDR
notation 10.1.16.0/24. If you want more, ``widen'' the netmask or
lower the number after the slash. Or add more lines for the apropriate
subnets.


Well, you specify the local host and only the local host. Apart from
127.0.0.0/8 referring by convention to only *this* host and never the
local network; the number after the / specifies the number of bits
counted from the left that are ``fixed''.

32 bits out of 32 fixed means only one address. Not what you want here.

You didn't specify the range of addresses that do you want to give
access, but this might point you in the right direction.


[1] Usually except .0 and .255 as the first and last of the range are
reserved for broadcast while only the last is usually used for that.
Why? Blame history.

--
j p d (at) d s b (dot) t u d e l f t (dot) n l .
This message was originally posted on Usenet in plain text.
Any other representation, additions, or changes do not have my
consent and may be a violation of international copyright law.