Re: best method of reloading pg_hba.conf

Поиск
Список
Период
Сортировка
От Hannu Krosing
Тема Re: best method of reloading pg_hba.conf
Дата
Msg-id 3BED27EF.BD6804C1@tm.ee
обсуждение исходный текст
Ответ на Re: best method of reloading pg_hba.conf  (Bruce Momjian <pgman@candle.pha.pa.us>)
Список pgsql-hackers
Fernando Nasser wrote:
> 
> 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.

You could do the writing in a proper way - write to temp file and then
rename.

> 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.

Well, that much I already knew ;)

Except for sendmail where I must run newaliases, that is.


Sending a HUP is actually ok with me, it just came as a surprise.

----------------------
Hannu


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: RelationFlushRelation() or RelationClearRelation()
Следующее
От: Jean-Michel POURE
Дата:
Сообщение: Diff/Patch integration -> SQL cvs clone