Skip to content

docs: synchronize sequences at a logical replication cutover - #422

Open
Loyal-Young wants to merge 1 commit into
IvorySQL:masterfrom
Loyal-Young:contest/docs-logical-sequence-cutover
Open

Loyal-Young wants to merge 1 commit into
IvorySQL:masterfrom
Loyal-Young:contest/docs-logical-sequence-cutover

Conversation

@Loyal-Young

Copy link
Copy Markdown

Describe which sequence state stays on the publisher and how to transfer last_value and is_called before enabling writes on the subscriber. Include the effect of reserved and explicitly imported IDs.

Verification

Ran a publication and subscription on two IvorySQL instances. Verified that the row with ID 842 replicated while the subscriber sequence kept its initial state, copied the sequence state, and confirmed the next ID of 843. Also verified is_called=false and rendered both pages.

Assisted-by: Codex:GPT-6
Percentage of AI-generated code: 100%

Signed-off-by: 王泽浩 <266632325+Loyal-Young@users.noreply.github.com>
@github-actions
github-actions Bot temporarily deployed to pull request November 16, 2026 15:50 Inactive
@github-actions

Copy link
Copy Markdown

🚀 IvorySQL-Docs Preview Ready

@Loyal-Young

Copy link
Copy Markdown
Author

Could a maintainer review and merge this logical-replication cutover guide if it looks good? The examples verified that a replicated row leaves sequence state on the publisher, and that copying last_value and is_called produces the expected next ID. The documentation preview checks are passing.

This branch was previously deployed

1 inactive deployment
pull request — 9f321f75 Deployed Nov 16, 2026 by github-actions[bot]
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

None yet

Projects

None yet

Development

Successfully merging this pull request may close these issues.

1 participant