| Slony-I 2.1.4 Documentation | ||||
|---|---|---|---|---|
| Prev | Fast Backward | Chapter 8. Schema schemadoc | Fast Forward | Next |
8.4. Table: sl_confirm
Holds confirmation of replication events. After a period of time, Slony removes old confirmed events from both this table and the sl_event table.
Structure of sl_confirm
- con_origin
integer
The ID # (from sl_node.no_id) of the source node for this event
- con_received
integer
- con_seqno
bigint
The ID # for the event
- con_timestamp
timestamp with time zone DEFAULT (timeofday())::timestamp with time zone
When this event was confirmed
Indexes on sl_confirm
- sl_confirm_idx1
con_origin, con_received, con_seqno
- sl_confirm_idx2
con_received, con_seqno