Documentation
 
 
 

STORE NODE

Name

STORE NODE --  Initialize edb-async-replic 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

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.

Example

     STORE NODE ( ID = 2, COMMENT = 'Node 2');
    
 
 ©2004-2007 EnterpriseDB All Rights Reserved