Re: best method of reloading pg_hba.conf - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: best method of reloading pg_hba.conf
Date
Msg-id 200111092346.fA9NkEf01637@candle.pha.pa.us
Whole thread Raw
In response to best method of reloading pg_hba.conf  (David Ford <david@blue-labs.org>)
Responses Re: best method of reloading pg_hba.conf
List pgsql-hackers
> > Performance.  Peter E found that considerable startup time was being
> > wasted reading the file.
> 
> But can't we read it only when needed ?
> 
> Just stat'ing it should be much cheaper than reading it each time.

We thought about that but it seems we could be reading partial writes to
the file.  This way the administrator controls when the changes become
effective.

--  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: Tom Lane
Date:
Subject: Re: 'real' strange problem in 7.1.3
Next
From: Tom Lane
Date:
Subject: Re: best method of reloading pg_hba.conf