From: "Sandeep Gudibanda" <[EMAIL PROTECTED]> >Hi Melvin, > >Thanks for the info.I have couple of queries, > >a) Why do we have > >drop node (id = 1, event node = 2) twice? > >b) And even > >store node (id=1,event node = 2, comment = 'Slave node'); > >we have it twice. > >c) No action needed other than starting slon on node1. Am i correct? > >Thanks in Advcance, > >Sandeep G a) You do not have it twice. I merely pointed out that it is in the documentation. b) After you drop the node (as instructed per the failover, you need to re-add it. So you need to do the (store node) command. I errored by including it twice. Please note, after running the script, you will need to A. Start the slon process on node 1 B. subscribe node 1 as a slave to node 2. I have corrected a re-attached the script for you convenience. Please change the variable names as needed. ================================================================================================== slonik <<_EOF_ #-- # define the namespace the replication system uses in our example it is # slony_example #-- CLUSTER NAME = $COMETCLUSTER; #-- # admin conninfo's are used by slonik to connect to the nodes one for each # node on each side of the cluster, the syntax is that of PQconnectdb in # the C-API # -- node 1 admin conninfo = 'dbname=$NODE1NAME host=$NODE1HOST port=$PGPORT user=$REPLICATIONUSER'; node 2 admin conninfo = 'dbname=$NODE2NAME host=$NODE2HOST1 port=$PGPORT user=$REPLICATIONUSER'; STORE NODE ( ID = 1, COMMENT = 'Your Comments Here' ); store path (server = 1, client = 2, conninfo='dbname=$NODE1NAME host=$NODE1HOST port=$PGPORT user=$REPLICATIONUSER '); store path (server = 2, client = 1, conninfo='dbname=$NODE2NAME host=$NODE2HOST port=$PGPORT user=$REPLICATIONUSER '); store listen (origin=1, provider = 1, receiver =2); store listen (origin=2, provider = 2, receiver =1); _EOF_ -- Melvin Davidson CCT - Database Developer 303-798-9228 ext. 305 |
_______________________________________________ Slony1-general mailing list [email protected] http://gborg.postgresql.org/mailman/listinfo/slony1-general
