Re: [HACKERS] subscription worker doesn't start immediately on eabled - Mailing list pgsql-hackers

From Masahiko Sawada
Subject Re: [HACKERS] subscription worker doesn't start immediately on eabled
Date
Msg-id CAD21AoBZTrF8pucd3Xb+DKrx93Dr3zpNPOnSSB4zj4V7h_y5_A@mail.gmail.com
Whole thread Raw
In response to Re: [HACKERS] subscription worker doesn't start immediately on eabled  (Fujii Masao <masao.fujii@gmail.com>)
Responses Re: [HACKERS] subscription worker doesn't start immediately on eabled  (Peter Eisentraut <peter.eisentraut@2ndquadrant.com>)
List pgsql-hackers
On Thu, Apr 27, 2017 at 12:51 AM, Fujii Masao <masao.fujii@gmail.com> wrote:
> On Wed, Apr 26, 2017 at 4:03 PM, Kyotaro HORIGUCHI
> <horiguchi.kyotaro@lab.ntt.co.jp> wrote:
>> At Tue, 25 Apr 2017 14:45:03 -0400, Peter Eisentraut <peter.eisentraut@2ndquadrant.com> wrote in
<3d6a1bd0-08ce-301d-3336-ec9f623a315d@2ndquadrant.com>
>>> On 4/6/17 08:24, Kyotaro HORIGUCHI wrote:
>>> > The attached patch wakes up launcher when a subscription is
>>> > enabled. This fails when a subscription is enabled immedaitely
>>> > after disabling but it won't be a matter.
>>>
>>> committed, thanks
>>
>> Thanks!
>
> This patch makes me think that CREATE SUBSCRIPTION should also wake up
> the launcher only when ENABLE is specified. Patch attached. Thought?
>

That makes sense to me. Since NOCONNECT option changes some default
values including ENABLED to false I think we should apply it also when
NOCONNECT is specified?

Regards,

--
Masahiko Sawada
NIPPON TELEGRAPH AND TELEPHONE CORPORATION
NTT Open Source Software Center



pgsql-hackers by date:

Previous
From: Masahiko Sawada
Date:
Subject: Re: [HACKERS] Interval for launching the table sync worker
Next
From: Masahiko Sawada
Date:
Subject: Re: [HACKERS] [PostgreSQL 10] default of hot_standby should be "on"?