hugh at math.byu.edu
Thu May 8 09:36:47 MDT 2003
I am playing around with the version of postgres from rh9. they added a
new column to the pg_hba.conf file that allows you to specify
users/groups that are allowed to connect.
My question is this. I have a machine that will have multiple databases
within the instance of postgres. new ones will be created to do
I have a particular database that I only want members of a certain group
to be able to access, but be able to allow anyone else to access any
other database. I can't seem to find a way to do this.
so far I have
host specialdb +specialgroup ip netmask md5
host specialdb +specialgroup 127.0.0.1 255.255.255.255 md5
local specialdb +specialgroup md5
host all all 127.0.0.1 255.255.255.255 md5
local all all md5
which keeps anyone not on the local machine off, but any user on the
local machine can get to the specialdb regardless of their membership in
what I'd really like is a directive like:
host specialdb !+specialgroup reject
but there doesn't seem to be one. Anyone know how to be exclusive
rather than inclusive (which is how the documentation says to do it)?
More information about the LUG