store path(7)

NAME

STORE PATH - Configure Slony-I node connection

STORE PATH (options);

Configures how the replication daemon of one node connects
to the database 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 overwritten.
The conninfo string must contain all information to con
nect 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 connec
tions are not established unless they are required to actually
transfer events or confirmations because of listen entries or da
ta because of subscriptions.
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 .

STORE PATH ( SERVER = 1, CLIENT = 2,: CONNINFO = 'dbname=testdb host=server1 us; er=slony'
);

No application-visible locking should take place.