init cluster(7)
NAME
INIT CLUSTER - Initialize Slony-I cluster
SYNOPSIS
INIT CLUSTER [ID = integer] [COMMENT = 'string']
DESCRIPTION
Initialize the first node in a new Slony-I replication cluster. The
initialization process consists of creating the cluster namespace,
loading all the base tables, functions, procedures and initializing the
node, using "schemadocinitializelocalnode( integer, text )" [not available as a man page] and "schemadocenablenode( integer )" [not available
as a man page].
ID The unique, numeric ID number of the node.
- COMMENT = 'comment text'
- A descriptive text added to the node entry in the table "sl_node" [not available as a man page].
- For this process to work, the SQL scripts of the Slony-I system must be installed on the DBA workstation (the computer currently executing the slonik utility), while on the system where the node database is running the shared objects of the Slony-I system must be installed in the PostgreSQL library directory. Also the procedural language PL/pgSQL is assumed to already be installed in the target database.
EXAMPLE
- INIT CLUSTER (
- ID = 1,
COMMENT = 'Node 1' - );
Note- This command functions very similarly to STORE NODE(7), the difference being that INIT CLUSTER does not need to draw configuration from other existing nodes.
LOCKING BEHAVIOUR
This command creates a new namespace and configures tables therein; no
public objects should be locked during the duration of this.
VERSION INFORMATION
- This command was introduced in Slony-I 1.0