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 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  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 unavailable. Default is 10.

       This uses “schemadocstorepath(p_pa_connretry integer, p_pa_conninfo  integer,  p_pa_client
       text, p_pa_server 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

                                           28 July 2024                      SLONIK STORE PATH(7)