UNSUBSCRIBE SET - End replication of Slony-I set
Contents
Dangerous/Unintuitive Behaviour
Resubscribing an unsubscribed set requires a completefreshcopy of data from the provider to be trans‐
ferred since the tables have been subject to possible independent modifications.
Description
Stops the subscriber from replicating the set. The tables are opened up for full access by the client ap‐
plication on the former subscriber. The tables are not truncated or otherwise modified. All original
triggers, rules and constraints are restored.
ID = ival
ID of the set to unsubscribe
RECEIVER = ival
Node ID of the (former) subscriber
Example
UNSUBSCRIBE SET (
ID = 1,
RECEIVER = 3
);
Locking Behaviour
Exclusive locks on each replicated table will be taken out on the subscriber in order to drop replication
triggers from the tables and restore other triggers/rules.
Name
UNSUBSCRIBE SET - End replication of Slony-I set
Slonik Event Confirmation Behaviour
Slonik waits for the command submitted to the previous event node to be confirmed on the specified event
node before submitting this command.
Synopsis
UNSUBSCRIBESET(options);
Version Information
This command was introduced in Slony-I 1.0
19 September 2024 SLONIKUNSUBSCRIBESET(7)
