From: | "Ross J(dot) Reedstrom" <reedstrm(at)rice(dot)edu> |
---|---|
To: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: Problem with reloading groups in pg_hba.conf |
Date: | 2002-03-21 16:49:16 |
Message-ID: | 20020321164916.GA9887@rice.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Thu, Mar 21, 2002 at 11:38:05AM -0500, Bruce Momjian wrote:
>
> I am handling it like pg_shadow. The problem is that because I expand
> pg_group inside the pg_hba tokens, I have to retokenize pg_hba.conf too
> after pg_group changes. I assumed we didn't want pg_hba.conf
> retokenized on a password change and only on a pg_ctl reload.
>
> My new code has a separate pg_group token list which is not expanded
> into the pg_hba.conf token list and is traversed for every connection.
Hmm, your trading performance on every connection for less work on the
rare event of a password change? What's wrong with reparsing pg_hba.conf
at password/group change? Streamline the common case, don't optimize for
the rare condition.
Ross
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2002-03-21 16:52:04 | Re: Problem with reloading groups in pg_hba.conf |
Previous Message | Bruce Momjian | 2002-03-21 16:38:05 | Re: Problem with reloading groups in pg_hba.conf |