Re: Make wal_receiver_timeout configurable per subscription

2025-05-27 Thread Fujii Masao
On 2025/05/22 21:21, Amit Kapila wrote: On Wed, May 21, 2025 at 6:04 PM Fujii Masao wrote: On 2025/05/20 18:13, vignesh C wrote: If we set the wal_receiver_timeout configuration using ALTER ROLE for the subscription owner's role, the apply worker will start with that value. However, any cha

Re: Make wal_receiver_timeout configurable per subscription

2025-05-22 Thread Amit Kapila
On Wed, May 21, 2025 at 6:04 PM Fujii Masao wrote: > > On 2025/05/20 18:13, vignesh C wrote: > > If we set the wal_receiver_timeout configuration using ALTER ROLE for > > the subscription owner's role, the apply worker will start with that > > value. However, any changes made via ALTER ROLE ... SE

Re: Make wal_receiver_timeout configurable per subscription

2025-05-21 Thread Fujii Masao
On 2025/05/20 18:13, vignesh C wrote: If we set the wal_receiver_timeout configuration using ALTER ROLE for the subscription owner's role, the apply worker will start with that value. However, any changes made via ALTER ROLE ... SET wal_receiver_timeout will not take effect for an already runn

Re: Make wal_receiver_timeout configurable per subscription

2025-05-20 Thread Masahiko Sawada
On Tue, May 20, 2025 at 2:13 AM vignesh C wrote: > > On Tue, 20 May 2025 at 03:16, Michael Paquier wrote: > > > > On Mon, May 19, 2025 at 11:19:48AM -0400, Robert Haas wrote: > > > The advantage of Fujii-san's proposal is that it is very simple to > > > implement. A subscription option would inde

Re: Make wal_receiver_timeout configurable per subscription

2025-05-20 Thread vignesh C
On Tue, 20 May 2025 at 03:16, Michael Paquier wrote: > > On Mon, May 19, 2025 at 11:19:48AM -0400, Robert Haas wrote: > > The advantage of Fujii-san's proposal is that it is very simple to > > implement. A subscription option would indeed be better, but it would > > also be considerably more compl

Re: Make wal_receiver_timeout configurable per subscription

2025-05-19 Thread Michael Paquier
On Mon, May 19, 2025 at 11:19:48AM -0400, Robert Haas wrote: > The advantage of Fujii-san's proposal is that it is very simple to > implement. A subscription option would indeed be better, but it would > also be considerably more complex. Why not start simple and if someone > wants to do the work t

Re: Make wal_receiver_timeout configurable per subscription

2025-05-19 Thread Robert Haas
On Mon, May 19, 2025 at 2:48 AM Amit Kapila wrote: > The GUC wal_receiver_interval is also used for physical replication > and logical launcher, so won't making it userset can impact those > cases as well, but maybe that is okay. However, for the specific case > you are worried about, isn't it bet

Re: Make wal_receiver_timeout configurable per subscription

2025-05-19 Thread Amit Kapila
On Fri, May 16, 2025 at 9:11 PM Fujii Masao wrote: > > When multiple subscribers connect to different publisher servers, > it can be useful to set different wal_receiver_timeout values for > each connection to better detect failures. However, this isn't > currently possible, which limits flexibili

Re: Make wal_receiver_timeout configurable per subscription

2025-05-16 Thread Srinath Reddy Sadipiralla
On Fri, May 16, 2025 at 9:11 PM Fujii Masao wrote: > Hi, > > When multiple subscribers connect to different publisher servers, > it can be useful to set different wal_receiver_timeout values for > each connection to better detect failures. However, this isn't > currently possible, which limits fl

Make wal_receiver_timeout configurable per subscription

2025-05-16 Thread Fujii Masao
Hi, When multiple subscribers connect to different publisher servers, it can be useful to set different wal_receiver_timeout values for each connection to better detect failures. However, this isn't currently possible, which limits flexibility in managing subscriptions. To address this, I'd like