|ID = ival|
|ID of the set to unsubscribe|
|RECEIVER = ival|
|Node ID of the (former) subscriber|
UNSUBSCRIBE SET ( ID = 1, RECEIVER = 3 );
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.
Slonik waits for the command submitted to the previous event node to be confirmed on the specified event node before submitting this command.
Resubscribing an unsubscribed set requires a complete fresh copy of data from the provider to be transferred since the tables have been subject to possible independent modifications.
This command was introduced in Slony-I 1.0
|SLONIK UNSUBSCRIBE SET (7)||18 January 2015|