| Slony-I 1.2.23 Documentation | ||||
|---|---|---|---|---|
| Prev | Fast Backward | Chapter 1. Schema schemadoc | Fast Forward | Next |
1.3. 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 without time zone DEFAULT (timeofday())::timestamp without 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