On Tue, Feb 17, 2026 at 4:51 PM Ashutosh Sharma <[email protected]> wrote: > > > How about retaining ALTER SUBSCRIPTION ... REFRESH SEQUENCES command? >
Yes, Shveta and myself also advocated the same for the upgrade case. > It can be useful in scenarios where automatic sequence replication > cannot be enabled, for example, due to the max_worker_processes limit > on the server preventing a new worker from being registered. Since > increasing max_worker_processes requires a server restart, which the > user may not want to perform immediately, this command would provide a > way to manually synchronize the sequences. > Good point. I think we won't be able to launch sync workers even when we reach max_logical_replication_workers limit. So, this is one more reason to retain the REFRESH SEQUENCES command. -- With Regards, Amit Kapila.
