#!/bin/sh

# **********
# test_1_handover_to_2
#
#	Script to change the origin of set 1 from node 22 back to node 11.
#	This still requires that both nodes are 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 = 22);
	move set (id = 1, old origin = 22, new origin = 11);
_EOF_