Re: Proposal: GUC to control starting/stopping logical subscription workers

2025-09-15 Thread Bharath Rupireddy
Hi, On Tue, Sep 9, 2025 at 1:16 PM SATYANARAYANA NARLAPURAM wrote: > >> If I understand correctly, the end effect is similar to disabling all >> subscriptions. Why not just add ALTER SUBSCRIPTION ... DISABLE for all >> subscriptions in the failover work flow? Migration of logical >> replication s

Re: Proposal: GUC to control starting/stopping logical subscription workers

2025-09-15 Thread SATYANARAYANA NARLAPURAM
Hi Euler, On Wed, Sep 10, 2025 at 5:11 PM Euler Taveira wrote: > On Wed, Aug 13, 2025, at 12:40 AM, SATYANARAYANA NARLAPURAM wrote: > > I couldn't find a previous discussion on a new GUC to globally enable > > or disable logical subscription workers at the instance level. So > > starting a new t

Re: Proposal: GUC to control starting/stopping logical subscription workers

2025-09-10 Thread Euler Taveira
On Wed, Aug 13, 2025, at 12:40 AM, SATYANARAYANA NARLAPURAM wrote: > I couldn't find a previous discussion on a new GUC to globally enable > or disable logical subscription workers at the instance level. So > starting a new thread on this. > max_logical_replication_workers. > In multi-region or

Re: Proposal: GUC to control starting/stopping logical subscription workers

2025-09-09 Thread SATYANARAYANA NARLAPURAM
HI Bharat, > > If I understand correctly, the end effect is similar to disabling all > subscriptions. Why not just add ALTER SUBSCRIPTION ... DISABLE for all > subscriptions in the failover work flow? Migration of logical > replication slots docs says so - > https://www.postgresql.org/docs/18/log

Re: Proposal: GUC to control starting/stopping logical subscription workers

2025-09-08 Thread Bharath Rupireddy
Hi, On Tue, Aug 12, 2025 at 8:40 PM SATYANARAYANA NARLAPURAM wrote: > > I couldn't find a previous discussion on a new GUC to globally enable or > disable logical subscription workers at the instance level. So starting a new > thread on this. > > In multi-region or high-availability setups, a p

Proposal: GUC to control starting/stopping logical subscription workers

2025-08-12 Thread SATYANARAYANA NARLAPURAM
Hi all, I couldn't find a previous discussion on a new GUC to globally enable or disable logical subscription workers at the instance level. So starting a new thread on this. In multi-region or high-availability setups, a promoted standby often requires a controlled switchover before it should st