Sun Nov 21 18:25:26 PST 2004
- Previous message: [Slony1-general] Adding a new subscriber ...
- Next message: [Slony1-general] Node #s significant outside of slonik script?
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Just adding on the 2nd slon subscriber for the DNS, and have already built
up all my 'scripts' to do this, but am curious about the significance of
the node # ... for instance, to add the new (3rd node), my script looks
like:
slonik <<_EOF_
# ----
# This defines which namespace the replication system uses
# ----
cluster name = $CLUSTER;
# ----
# Admin conninfo's are used by the slonik program to connect
# to the node databases. So these are the PQconnectdb arguments
# that connect from the administrators workstation (where
# slonik is executed).
# ----
node 1 admin conninfo = 'dbname=$DBNAME1 host=$HOST1 user=$SLONY_USER';
node 2 admin conninfo = 'dbname=$DBNAME2 host=$HOST2 user=$SLONY_USER';
# ----
# Create the second node, tell the two nodes how to connect to
# each other and that they should listen for events on each
# other. Note that these conninfo arguments are used by the
# slon daemon on node 1 to connect to the database of node 2
# and vice versa. So if the replication system is supposed to
# use a separate backbone network between the database servers,
# this is the place to tell it.
# ----
store node ( id = 2, comment = 'Node 2' );
store path ( server = 1, client = 2,
conninfo = 'dbname=$DBNAME1 host=$HOST1 user=$SLONY_USER');
store path ( server = 2, client = 1,
conninfo = 'dbname=$DBNAME2 host=$HOST2 user=$SLONY_USER');
store listen ( origin = 1, provider = 1, receiver = 2 );
store listen ( origin = 2, provider = 2, receiver = 1 );
_EOF_
Now, is the # that my 'node # admin' is using just a "connection handle"
to be used throughout the script, or do I need to change "2" to "3" for
the new subscriber? And increment accordingly for each new subscriber?
Then again, the 'store path' line seems to indicate the 'increment' is
required ... but just wish to clarify ...
Thanks ...
----
Marc G. Fournier Hub.Org Networking Services (http://www.hub.org)
Email: scrappy at hub.org Yahoo!: yscrappy ICQ: 7615664
- Previous message: [Slony1-general] Adding a new subscriber ...
- Next message: [Slony1-general] Node #s significant outside of slonik script?
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list