SLONIK STORE PATH(7) Configuration and Action commands SLONIK STORE PATH(7)NAME
STORE PATH - Configure Slony-I node connection
SYNOPSIS
STORE PATH (options);
DESCRIPTION
Configures how the replication daemon of one node connects to the data‐
base of another node. If the replication system is supposed to use a
special backbone network segment, this is the place to user the special
IP addresses or hostnames. An existing configuration can be overwrit‐
ten.
The conninfo string must contain all information to connect to the
database as the replication superuser. The names ``server'' or
``client'' have nothing to do with the particular role of a node within
the cluster configuration. It should be simply viewed as ``the server''
has the message or data that ``the client is supposed to get.'' For a
simple 2 node setup, paths into both directions must be configured.
It does not do any harm to configure path information from every node
to every other node (full cross product). The connections are not
established unless they are required to actually transfer events or
confirmations because of listen entries or data because of subscrip‐
tions.
SERVER = ival
Node ID of the database to connect to.
CLIENT = ival
Node ID of the replication daemon connecting.
CONNINFO = string
PQconnectdb() argument to establish the connection.
CONNRETRY = ival
Number of seconds to wait before another attempt to connect is
made in case the server is unavailable. Default is 10.
This uses storepath(integer,integer,text,integer) .
EXAMPLE
STORE PATH ( SERVER = 1, CLIENT = 2,
CONNINFO = 'dbname=testdb host=server1 user=slony'
);
LOCKING BEHAVIOUR
No application-visible locking should take place.
SLONIK EVENT CONFIRMATION BEHAVIOUR
Slonik does not wait for event confirmations before performing this
command
VERSION INFORMATION
This command was introduced in Slony-I 1.0
18 January 2015 SLONIK STORE PATH(7)
