Re: pg_hba.conf pre-parsing change - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: pg_hba.conf pre-parsing change
Date
Msg-id 200107312314.f6VNEnG17777@candle.pha.pa.us
Whole thread Raw
In response to pg_hba.conf pre-parsing change  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: pg_hba.conf pre-parsing change
List pgsql-hackers
> Bruce Momjian - CVS <momjian@hub.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@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: Bruce Momjian
Date:
Subject: Re: Re: [PATCHES] Allow IDENT authentication on local connections (Linux only)
Next
From: Tom Lane
Date:
Subject: Re: pg_hba.conf pre-parsing change