NAME

       STORE NODE - Initialize Slony-I node

SYNOPSIS

       STORE NODE (options);

DESCRIPTION

       Initialize a new node and add it to the configuration of an existing cluster.

       The  initialization  process consists of creating the cluster namespace in the new node (the database it‐
       self must already exist), loading all the base tables, functions, procedures and initializing  the  node.
       The existing configuration of the rest of the cluster is copied from the ‘event node’.

       ID = ival
              The unique, immutable numeric ID number of the new node.

              Note that the ID is immutable because it is used as the basis for inter-node event communications.

       COMMENT = 'description'
              A descriptive text added to the node entry in the table “sl_node” [not available as a man page]

       SPOOLNODE = boolean
              Specifies  that  the  new  node  is a virtual spool node for file archiving of replication log. If
              true, slonik will not attempt to initialize a database with the replication schema.
              Warning

              Never use the SPOOLNODE value - no released version of Slony-I has ever behaved in the fashion de‐
              scribed in the preceding fashion. Log shipping, as it finally emerged in 1.2.11, does not  require
              initializing ‘spool nodes’.

       EVENT NODE = ival
              The  ID of the node used to create the configuration event that tells all existing nodes about the
              new node. It must be the ID of a pre-existing node in the cluster, not the ID of the new node.

       This uses “schemadocinitializelocalnode(p_comment integer, p_local_node_id text)” [not available as a man
       page] and “schemadocenablenode(p_no_id integer)” [not available as a man page].

EXAMPLE

            STORE NODE ( ID = 2, COMMENT = 'Node 2', EVENT NODE = 1 );

LOCKING BEHAVIOUR

       This command creates a new namespace and configures tables therein; no public objects  should  be  locked
       during the duration of this.

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.

VERSION INFORMATION

       This command was introduced in Slony-I 1.0. The SPOOLNODE parameter was introduced in  version  1.1,  but
       was  vestigial  in  that  version.  The described functionality for SPOOLNODE arrived in version 1.2, but
       SPOOLNODE was not used for this purpose. In later versions, hopefully SPOOLNODE will be unavailable.

       In version 2.0, the default value for EVENT NODE was removed, so a node must be specified.

                                                 1 November 2021                            SLONIK STORE NODE(7)