Re: best method of reloading pg_hba.conf

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


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Bug?? -- Alter table drop constraint doesn't seem to work on a primary key constraint in 7.2beta2
Следующее
От: Tom Lane
Дата:
Сообщение: Re: best method of reloading pg_hba.conf