Thu Aug 20 23:47:24 PDT 2009
- Previous message: [Slony1-general] How does it work if has different sets on different nodes?
- Next message: [Slony1-general] How do you rejoin a dropped nodes?
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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.
- Previous message: [Slony1-general] How does it work if has different sets on different nodes?
- Next message: [Slony1-general] How do you rejoin a dropped nodes?
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list