slony-test/adsl/test_difference.sh


#echo "** sync"
#slonik_execute_script -c 'select now();' 1 | slonik

op='=='
echo $0 $1 | grep 'diff' >/dev/null && op='!='

echo "name [$0 $1] op [$op]"

psql="sudo -u postgres psql adsl"
master="`$psql -p 5001 -c 'select * from po_mjesecima'`"
echo -e "## MASTER\n$master"
slave=''
oldslave=''
sleep=1
while [ ! "$master" $op "$slave" -o "$slave" == '' ] ; do
        slave="`$psql -p 5002 -c 'select * from po_mjesecima'`"
        if [ "$oldslave" != "$slave" ]
        then
                echo -e "$op SLAVE\n$slave"
        else
                #slonik_execute_script -c 'select now();' 1 | slonik
                ( slonik_print_preamble ; echo 'sync(id=1);' ) | slonik
                ( slonik_print_preamble ; echo 'sync(id=2);' ) | slonik
                echo -n "."
                sleep $sleep
                sleep=`expr $sleep \* 2`
        fi
        oldslave="$slave"
done

echo "** OK -- master $op slave **"
1
2	#echo "** sync"
3	#slonik_execute_script -c 'select now();' 1 \| slonik
4
5	op='=='
6	echo $0 $1 \| grep 'diff' >/dev/null && op='!='
7
8	echo "name [$0 $1] op [$op]"
9
10	psql="sudo -u postgres psql adsl"
11	master="`$psql -p 5001 -c 'select * from po_mjesecima'`"
12	echo -e "## MASTER\n$master"
13	slave=''
14	oldslave=''
15	sleep=1
16	while [ ! "$master" $op "$slave" -o "$slave" == '' ] ; do
17	slave="`$psql -p 5002 -c 'select * from po_mjesecima'`"
18	if [ "$oldslave" != "$slave" ]
19	then
20	echo -e "$op SLAVE\n$slave"
21	else
22	#slonik_execute_script -c 'select now();' 1 \| slonik
23	( slonik_print_preamble ; echo 'sync(id=1);' ) \| slonik
24	( slonik_print_preamble ; echo 'sync(id=2);' ) \| slonik
25	echo -n "."
26	sleep $sleep
27	sleep=`expr $sleep \* 2`
28	fi
29	oldslave="$slave"
30	done
31
32	echo " OK -- master $op slave "