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

From Tom Lane
Subject pg_hba.conf pre-parsing change
Date
Msg-id 27786.996620706@sss.pgh.pa.us
Whole thread Raw
Responses Re: pg_hba.conf pre-parsing change  (Bruce Momjian <pgman@candle.pha.pa.us>)
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.)

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?
        regards, tom lane


pgsql-hackers by date:

Previous
From: mlw
Date:
Subject: Re: Update to 7.1.2 Question...
Next
From: Bruce Momjian
Date:
Subject: Re: Re: [PATCHES] Allow IDENT authentication on local connections (Linux only)