Re: pg_hba.conf pre-parsing change

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-hackers(at)postgreSQL(dot)org
Subject: Re: pg_hba.conf pre-parsing change
Date: 2001-07-31 23:14:49
Message-ID: 200107312314.f6VNEnG17777@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers pgsql-hackers

> Bruce Momjian - CVS <momjian(at)hub(dot)org> writes:
> > Load pg_hba.conf and pg_ident.conf on startup and SIGHUP into List of
> > Lists, and use that for user validation.
>
> While this should be a nice speedup, it bothers me somewhat that the old
> behavior of reacting immediately to pg_hba.conf and pg_ident.conf
> updates has been changed. (And you didn't update the documentation to
> say so --- tsk tsk.)

Oh, I didn't realize we documented that.

> Would it make sense to do fstat calls on these files and reload whenever
> we observe that the file modification time has changed? That'd be an
> additional kernel call per connection attempt, so I'm not at all sure
> I want to do it ... but it ought to be debated. Comments anyone?

We could, but we don't with postgresql.conf so it made sense to keep the
behavior the same for the two files.

--
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

In response to

Responses

Browse pgsql-committers by date

  From Date Subject
Next Message Tom Lane 2001-07-31 23:20:14 Re: pg_hba.conf pre-parsing change
Previous Message Tom Lane 2001-07-31 23:05:06 pg_hba.conf pre-parsing change

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2001-07-31 23:20:14 Re: pg_hba.conf pre-parsing change
Previous Message Bruce Momjian 2001-07-31 23:11:34 Re: Re: [PATCHES] Allow IDENT authentication on local connections (Linux only)