Provided by: slony1-2-doc_2.2.11-4_all bug

NAME

       CREATE SET - Create Slony-I replication set

SYNOPSIS

       CREATE SET (options);

DESCRIPTION

       In the Slony-I replication system, replicated tables are organized in sets. As a general rule of thumb, a
       set should contain all the tables of one  application,  that  have  relationships.  In  a  well  designed
       application, this is equal to all the tables in one schema.

       The  smallest unit one node can subscribe for replication from another node is a set. A set always has an
       origin. In classical replication terms, that would be the ‘master.’  Since in Slony-I a node can  be  the
       ‘master’ over one set, while receiving replication data in the ‘slave’ role for another at the same time,
       this terminology may easily become misleading and should therefore be  replaced  with  ‘set  origin’  and
       ‘subscriber’.

       ID = ival
              ID of the set to be created.

       ORIGIN = ival
              Initial origin node of the set.

       COMMENT = 'string'
              A descriptive text added to the set entry.

              If none is provided, a default value is set; A replication set so boring no one thought to give it
              a name.

       This uses “schemadocstoreset(p_set_comment integer, p_set_id text)” [not available as a man page] .

EXAMPLE

            CREATE SET ( ID = 1,
                      ORIGIN = 1,
                      COMMENT = 'Tables for ticketing system' );

LOCKING BEHAVIOUR

       No application-visible locking should take place.

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. Slonik will also wait until any outstanding DROP SET commands are
       confirmed by all nodes before it submits the CREATE SET command.

VERSION INFORMATION

       This command was introduced in Slony-I 1.0

       Until version 1.2, it would crash if no comment was provided.

                                                  28 July 2024                              SLONIK CREATE SET(7)