On 04.06.24 12:57, Amit Kapila wrote:
2. Provide a command say Alter Subscription ... Replicate Sequences (or something like that) which users can perform before shutdown of the publisher node during upgrade. This will allow copying all the sequences from the publisher node to the subscriber node directly. Similar to previous approach, this could also be inconvenient for users.
I would start with this. In any case, you're going to need to write code to collect all the sequence values, send them over some protocol, apply them on the subscriber. The easiest way to start is to trigger that manually. Then later you can add other ways to trigger it, either by timer or around shutdown, or whatever other ideas there might be.
