Re: Possible problem with pg_reload_conf() and view pg_settings

Поиск
Список
Период
Сортировка
От Andrew Dunstan
Тема Re: Possible problem with pg_reload_conf() and view pg_settings
Дата
Msg-id 436C1E3A.5090708@dunslane.net
обсуждение исходный текст
Ответ на Re: Possible problem with pg_reload_conf() and view pg_settings  ("Qingqing Zhou" <zhouqq@cs.toronto.edu>)
Ответы Re: Possible problem with pg_reload_conf() and view  (Qingqing Zhou <zhouqq@cs.toronto.edu>)
Re: Possible problem with pg_reload_conf() and view pg_settings  (Tony Caduto <tony_caduto@amsoftwaredesign.com>)
Список pgsql-hackers
Дерево обсуждения 

Qingqing Zhou wrote:

>
>test=# LOG:  received SIGHUP, reloading configuration files
>
>test=# select setting from pg_settings where name = 'constraint_exclusion';
> setting
>---------
> off
>(1 row)
>
>test=# select setting from pg_settings where name = 'constraint_exclusion';
> setting
>---------
> on
>(1 row)
>
>
>-- Seems that's due to delay of process SIGHUP ...
>
>
>  
>

What's the delay? 1s? 5? 10?

cheers

andrew

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

Предыдущее
От: "Qingqing Zhou"
Дата:
Сообщение: Re: Possible problem with pg_reload_conf() and view pg_settings
Следующее
От: Qingqing Zhou
Дата:
Сообщение: Re: Possible problem with pg_reload_conf() and view