Provided by: slony1-doc_1.2.15-1_all bug
 

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 itself 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, numeric ID number of the new node.
 
        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.
 
        EVENT NODE = ival
               The  ID  of the node used to create the configuration event that
               tells all existing nodes about the new node. Default value is 1.
 
        This  uses  “schemadocinitializelocalnode( integer, text )” [not avail‐
        able as a man page] and “schemadocenablenode( integer )” [not available
        as a man page].
 

EXAMPLE

             STORE NODE ( ID = 2, COMMENT = ’Node 2’);
        This  command creates a new namespace and configures tables therein; no
        public objects should be locked during the duration of this.
        This command was introduced in Slony-I 1.0. The SPOOLNODE parameter was
        introduced  in  version  1.1, but was vestigal in that version. The de‐
        scribed functionality for SPOOLNODE arrives in version 1.2.
 
                                17 November 2008                  STORE NODE(7)