Re: Logical Replication of sequences

On Wed, Oct 8, 2025 at 9:13 AM Dilip Kumar <dilipbalaut@gmail.com> wrote:
>
> On Tue, Oct 7, 2025 at 5:46 PM Amit Kapila <amit.kapila16@gmail.com> wrote:
> >
> >
> > Yes, we can add the additional functionality for selective sequences
> > if required but do we have an option to allow upgrade of selective
> > tables?
>
> If the user is upgrading using logical replication, then there is an
> option to set up a replication from the current version to the next
> major version and then the user can selectively publish the table
> which is supposed to be streamed to the next major version. right?
>

Yes, that is possible. However, during the upgrade of the publisher
node, if the user wants to shift the workload to the subscriber then
ideally she should sync all sequences. But I think there could be
cases where users may wish to selectively replicate sequences, so we
can consider such cases as well once the main feature is committed.

--
With Regards,
Amit Kapila.