NAME

       STORE PATH - Configure Slony-I node connection

SYNOPSIS

       STORE PATH (options);

DESCRIPTION

       Configures how the replication daemon of one node connects to the database of another node. If the repli‐
       cation  system  is supposed to use a special backbone network segment, this is the place to user the spe‐
       cial IP addresses or hostnames. An existing configuration can be overwritten.

       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 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 unavail‐
              able. Default is 10.

       This uses “schemadocstorepath(p_pa_connretry integer, p_pa_conninfo integer, p_pa_client text, p_pa_serv‐
       er integer)” [not available as a man page].

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

                                                19 September 2024                           SLONIK STORE PATH(7)