Re: Logical Replication of sequences - Mailing list pgsql-hackers

From Amit Kapila
Subject Re: Logical Replication of sequences
Date
Msg-id CAA4eK1Jp-u-mg3+Tt-5SarkOQUZ2ZLVaChjk5qVt8cJT6_rBEg@mail.gmail.com
Whole thread Raw
In response to Re: Logical Replication of sequences  (Dilip Kumar <dilipbalaut@gmail.com>)
List pgsql-hackers
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.



pgsql-hackers by date:

Previous
From: Michael Paquier
Date:
Subject: Re: Remove custom redundant full page write description from GIN
Next
From: Peter Smith
Date:
Subject: Re: Add support for specifying tables in pg_createsubscriber.