Re: config files in /data

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: The Hermit Hacker <scrappy(at)hub(dot)org>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: config files in /data
Date: 2000-05-30 21:30:11
Message-ID: 200005302130.RAA23855@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2000-05-30 21:40:51 Re: secondary password files
Previous Message The Hermit Hacker 2000-05-30 21:24:29 Re: config files in /data