[lug] postgres

Hugh Brown 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
development, etc.

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 md5
local specialdb +specialgroup    md5
host    all         all   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 mailing list