bionic (7) SLONIK_UNLOCK_SET.7.gz

NAME

       UNLOCK SET - Unlock a Slony-I set that was locked

SYNOPSIS

       UNLOCK SET (options);

DESCRIPTION

       Unlocks a previously locked set.

       ID = ival
              ID of the set to unlock

       ORIGIN = ival
              Node ID of the current set origin

       This uses “schemadocunlockset(p_set_id integer)” [not available as a man page].

EXAMPLE

       UNLOCK SET (
          ID = 1,
          ORIGIN = 3
       );

LOCKING BEHAVIOUR

       Exclusive  locks  on  each  replicated  table  will  be taken out on the origin node, as the triggers are
       removed from each table that reject table updates.

SLONIK EVENT CONFIRMATION BEHAVIOUR

       Slonik does not wait for event confirmations before performing this command.

VERSION INFORMATION

       This command was introduced in Slony-I 1.0

                                                21 September 2017                           SLONIK UNLOCK SET(7)