Re: Problem with reloading groups in pg_hba.conf

Peter Eisentraut wrote:
> Tom Lane writes:
>
> > I don't think GRANT CONNECT fits into our setup at all. I also doubt
> > that it will be needed very much once we have schemas.
>
> People have many times asked for a way to alter the connection settings
> from within the database. For instance, you add users in the database,
> but then you need to go elsewhere to give that user any access. Consider
> GRANT CONNECT a built-in editor for pg_hba.conf. You don't have to
> actually store the information in two separate places.

I don't know. Automatically modifying a manually maintained config file
isn't too common a feature. One problem would be if you where modifying
the file in your editor and the backend rewrote the file.

I think groups will give use the ability to add/remove connection from
within the database. You just need to mention the group name in the
config file. My original idea was to automatically identify some group
name for each database but maybe that is too smart.

--
Bruce Momjian | http://candle.pha.pa.us
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