Re: Possible problem with pg_reload_conf() and view pg_settings - Mailing list pgsql-hackers

From Andrew Dunstan
Subject Re: Possible problem with pg_reload_conf() and view pg_settings
Date
Msg-id 436C1E3A.5090708@dunslane.net
Whole thread Raw
In response to Re: Possible problem with pg_reload_conf() and view pg_settings  ("Qingqing Zhou" <zhouqq@cs.toronto.edu>)
Responses 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>)
List 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 by date:

Previous
From: "Qingqing Zhou"
Date:
Subject: Re: Possible problem with pg_reload_conf() and view pg_settings
Next
From: Qingqing Zhou
Date:
Subject: Re: Possible problem with pg_reload_conf() and view