Christopher B. Browne's Home Page
cbbrowne@acm.org

8.16. Table: sl_setsync

SYNC information

Structure of sl_setsync

ssy_setid

integer PRIMARY KEY REFERENCES sl_set

ID number of the replication set

ssy_origin

integer REFERENCES sl_node

ID number of the node

ssy_seqno

bigint

Slony-I sequence number

ssy_snapshot

txid_snapshot

TXID in provider system seen by the event

ssy_action_list

text

action list used during the subscription process. At the time a subscriber copies over data from the origin, it sees all tables in a state somewhere between two SYNC events. Therefore this list must contains all log_actionseqs that are visible at that time, whose operations have therefore already been included in the data copied at the time the initial data copy is done. Those actions may therefore be filtered out of the first SYNC done after subscribing.

Google
Contact me at cbbrowne@acm.org