logo
Free, unlimited AI code reviews that run on commit
git-lrc git-lrc GitHub Install Now We'd appreciate a star git-lrc - Free, unlimited AI code reviews that run on commit | Product Hunt git-lrc - Free, unlimited AI code reviews that run on commit | Product Hunt

DROP SET - Discard Slony-I replication set

Description

       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].

Example

         DROP SET ( ID = 5,
                    ORIGIN = 2 );

Locking Behaviour

       On each node, this will require taking out exclusive locks on each replicated table in  order  to  modify
       the table schema to clean up the triggers and rules.

Name

       DROP SET - Discard Slony-I replication 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

DROPSET(options);

Version Information

       This command was introduced in Slony-I 1.0

                                                19 September 2024                             SLONIKDROPSET(7)

See Also