Re: Possible problem with pg_reload_conf() and view pg_settings

From: Andrew Dunstan <andrew(at)dunslane(dot)net>
To: Qingqing Zhou <zhouqq(at)cs(dot)toronto(dot)edu>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Possible problem with pg_reload_conf() and view pg_settings
Date: 2005-11-05 02:51:38
Message-ID: 436C1E3A.5090708@dunslane.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Qingqing Zhou 2005-11-05 02:55:37 Re: Possible problem with pg_reload_conf() and view
Previous Message Qingqing Zhou 2005-11-05 02:36:44 Re: Possible problem with pg_reload_conf() and view pg_settings