#!/bin/sh # ********** # test_1_handover_to_2 # # Script to change the origin of set 1 from node 11 to node 22. # This still requires that node 11 is alive. This is called # handover or move, not failover. # ********** export PATH TMPOUT=/tmp/output.$$ DB1=slony_test1 DB2=slony_test2 ###################################################################### # Move set 1 to node 2 ###################################################################### echo "**** Move set 1 to node 2" slonik <<_EOF_ cluster name = T1; node 11 admin conninfo = 'dbname=$DB1'; node 22 admin conninfo = 'dbname=$DB2'; lock set (id = 1, origin = 11); move set (id = 1, old origin = 11, new origin = 22); _EOF_