Re: config files in /data - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: config files in /data
Date
Msg-id 200005302130.RAA23855@candle.pha.pa.us
Whole thread Raw
In response to Re: config files in /data  (The Hermit Hacker <scrappy@hub.org>)
Responses Re: config files in /data  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
> On Tue, 30 May 2000, Bruce Momjian wrote:
> 
> > Seems we should have pg_hba.conf and other files in a separate
> > directory, not /data.
> > 
> > Comments?
> 
> I still say that pg_hba.conf should be eliminated altogether, in favor of
> something that is modifiable by anyone that the supeuser gives permissions
> to create databases too ... what's the point of having that ability if you
> can't access the database after its created?
> 
> Seems kinda anti-friendly to the DBA to be able to have
> "sub-ordinates" that can create users and databases, but has to be bug'd
> in order to allow them to be accessed ...
> 
> pg_hba should become another system table that can be modified with simple
> SQL queries, and is modifiable (readable?) only by those with createdb
> privileges ...

And have it dump like pg_shadow.  Yea, I guess we could do that.

--  Bruce Momjian                        |  http://www.op.net/~candle pgman@candle.pha.pa.us               |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026
 


pgsql-hackers by date:

Previous
From: Hannu Krosing
Date:
Subject: Re: Applying TOAST to CURRENT
Next
From: Tom Lane
Date:
Subject: Re: secondary password files