Provided by: slony1-doc_1.2.15-1_all
STORE NODE - Initialize Slony-I node
STORE NODE (options);
Initialize a new node and add it to the configuration of an existing
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
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].
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)