SLONIK_DROP_SET(7) - Linux man page online | Overview, conventions, and miscellany
Discard Slony-I replication set.
21 September 2017
SLONIK DROP SET(7) Slony-I 2.2.6 Documentation SLONIK DROP SET(7)
DROP SET - Discard Slony-I replication set
DROP SET (options);
Drop a set of tables from the Slony-I configuration. This automatically unsubscribes all
nodes from the set and restores the original triggers and rules on all subscribers.
ID = ival
ID of the set to be dropped.
ORIGIN = ival
Current origin node of the set.
This uses “schemadocdropset(p_set_id integer)” [not available as a man page].
DROP SET ( ID = 5,
ORIGIN = 2 );
On each node, this will require taking out exclusive locks on each replicated table in or‐
der to modify the table schema to clean up the triggers and rules.
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.
This command was introduced in Slony-I 1.0 21 September 2017 SLONIK DROP SET(7)