jackc / jackc/pglogrepl

How to resume replication?

Open
#40 11 comments 2 reactions 0 assignees View on GitHub
Dominant language
Go
Stars
546
Forks
83
Avg merge
2d 21h
Merged PRs (30d)
1

Description

If I created a publication and replication slot, added and updated some table records.
later I exited my program but the table records still be updated or added.
How can I resume the replication from last time when my program exited?
For example, I replicated 5 records while my program is running, after my program exited, added another 5 new records into postgresql tables, How can I continue to replicate the new table records from number 6 to 10 if my program run again?
call pglogrepl.SendStandbyStatusUpdate method or other methods?
@jackc Thanks!

Contributor guide

No contributing guide indexed for this repository

Research direction

Start by reading the issue's PostgreSQL logical replication scenario and the pglogrepl.SendStandbyStatusUpdate entry point. Determine how replication state is persisted and resumed after process exit, then document the steps needed to continue from the last replicated position and verify that new records are not replayed or skipped.

Written by the indexing model from the issue text.

Assessment

Tech stack
go, postgresql
Domain
databases
Issue type
Documentation
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
30/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.