Re: best method of reloading pg_hba.conf

Bruce Momjian wrote:
> 
> > > 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.
> 

Hannu,

It is not only much safer (you get a 2nd chance to check what you've
done)
but is also consistent with the behavior of other Unix daemons.


-- 
Fernando Nasser
Red Hat Canada Ltd.                     E-Mail:  fnasser@redhat.com
2323 Yonge Street, Suite #300
Toronto, Ontario   M4P 2C9