Re: Proposal for Allow postgresql.conf values to be changed via SQL [review]

Поиск
Список
Период
Сортировка
От Greg Smith
Тема Re: Proposal for Allow postgresql.conf values to be changed via SQL [review]
Дата
Msg-id 514B5A08.3030306@2ndQuadrant.com
обсуждение исходный текст
Ответ на Re: Proposal for Allow postgresql.conf values to be changed via SQL [review]  (Robert Haas <robertmhaas@gmail.com>)
Ответы Re: Proposal for Allow postgresql.conf values to be changed via SQL [review]  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Список pgsql-hackers
On 3/21/13 2:38 PM, Robert Haas wrote:
> Also, while I think that MOST people will probably want a SIGHUP right
> after SET PERSISTENT, I am not sure that EVERYONE will want that.  If
> you want it and it doesn't happen automatically, you can always do it
> by hand.

This is a fair position, and since that's how the feature as written 
right now works that helps.  I think proceeding this way needs to hand 
some sort of hint back to the user though, telling them the change isn't 
active until SIGHUP.  The path I don't want to see if where someone uses 
SET PERSISTENT and can't figure out why nothing changed.  It should be 
as obvious as we can make it to someone that the explicit reload is 
necessary.

-- 
Greg Smith   2ndQuadrant US    greg@2ndQuadrant.com   Baltimore, MD
PostgreSQL Training, Services, and 24x7 Support www.2ndQuadrant.com



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

Предыдущее
От: Simon Riggs
Дата:
Сообщение: Re: Should commit_delay be PGC_SIGHUP?
Следующее
От: Kevin Grittner
Дата:
Сообщение: Re: hstore compiler warnings