SIMPLE SOLUTIONS

SLONIK_CLUSTER_NAME(7) - Linux man page online | Overview, conventions, and miscellany

Preamble - identifying Slony-I cluster.

Chapter
21 September 2017
SLONIK CLUSTER NAME(7) Slony-I 2.2.6 Documentation SLONIK CLUSTER NAME(7)

NAME

CLUSTER NAME - preamble - identifying Slony-I cluster

SYNOPSIS

CLUSTER NAME = [clustername;]

DESCRIPTION

Must be the very first statement in every slonik script. It defines the namespace in which all Slony-I specific functions, procedures, tables and sequences are defined. The names‐ pace name is built by prefixing the given string literal with an underscore. This names‐ pace will be identical in all databases that participate in the same replication group. No user objects are supposed to live in this namespace, and the namespace is not allowed to exist prior to adding a database to the replication system. Thus, if you add a new node using pg_dump -s on a database that is already in the cluster of replicated databases, you will need to drop the namespace via the SQL command DROP SCHEMA _testcluster CASCADE; .

EXAMPLE

CLUSTER NAME = testcluster;

VERSION INFORMATION

This command was introduced in Slony-I 1.0
21 September 2017 SLONIK CLUSTER NAME(7)
Download raw manual
Index Slony-I 2.2.6 Documentation (+47) № 7 (+1560)
Go top