Bruce Momjian wrote:
>
> > Bruce Momjian wrote:
> > >
> > > > Is the best method of reloading pg_hba.conf to SIGHUP the master process?
> > >
> > > In 7.2, yes, pg_ctl restart or SIGHUP. On 7.1.X pg_hba.conf is reread
> > > on every connection request.
> >
> > Why was it changed ?
>
> 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.
----------------
Hannu