roctaiwan nettreeinc at gmail.com
Thu Aug 20 23:47:24 PDT 2009
DROP NODE command will also do "UNINSTALL NODE" command. The UNINSTALL NODE
from slony docunment explained:

"Restores all tables to the unlocked state, with all original user triggers,
constraints and rules, eventually added Slony-I specific serial key columns
dropped and the Slony-I schema dropped. The node becomes a standalone
database. The data is left untouched."

Explanation for DROP NODE on docunment:

"Drop a node. This command removes the specified node entirely from the
replication systems configuration. If the replication daemon is still
running on that node (and processing events), it will attempt to uninstall
the replication system and terminate itself. "

If after node dropped, docunment said if wants to rejoin the node back, it
will required to start from scratch. 

But what exacetly is from scratch? Do I have to do store node and store path
again? What should I do with initiate the cluster and creating sets, do I
have to do that? or it should still have the same configuarion information
as before it got dropped?

I have tried many way to rejoin back my node, but unsuccessful. Error
message sounds like tells me the node was exist and don't let me rejoin.
What's wrong?

Here is the error message:
<stdin>:21: Error: ev_origin for store_node cannot be the new node
<stdin>:21: database specified in <stdin>:5 reports no_id 2

and here is the script I tried to run:

#!/bin/sh

############################################
# Define Cluster Name, Database Name, Host #
# IP for Nodes and Database User Name.     #
############################################
CLUSTER=contact_cluster
DB=contactDB
Node1=172.22.4.224
Node2=172.22.4.221
Node3=172.22.4.222
Node4=172.22.4.223
U=postgres
slonik <<_EOF_
cluster name = $CLUSTER;

node 1 admin conninfo = 'dbname=$DB host=$Node1 user=$U';
node 2 admin conninfo = 'dbname=$DB host=$Node2 user=$U';
node 3 admin conninfo = 'dbname=$DB host=$Node3 user=$U';
node 4 admin conninfo = 'dbname=$DB host=$Node4 user=$U';

store node (id = 2, comment = 'Slave 1');

# Bi-directional replication to be established between Node 1 and Node 2.
store path (server = 1, client = 2, conninfo = 'dbname=$DB host=$Node1
user=$U');
store path (server = 2, client = 1, conninfo = 'dbname=$DB host=$Node2
user=$U');

_EOF_
-- 
View this message in context: http://www.nabble.com/How-do-you-rejoin-a-dropped-nodes--tp25074942p25074942.html
Sent from the Slony-I -- General mailing list archive at Nabble.com.



More information about the Slony1-general mailing list