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=''
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
                echo -n "."
                sleep 2
        fi
        oldslave="$slave"
done

echo "** OK -- master $op slave **"
1	dpavlin	1
2			#echo "** sync"
3			#slonik_execute_script -c 'select now();' 1 \| slonik
4
5	dpavlin	3	op='=='
6			echo $0 $1 \| grep 'diff' >/dev/null && op='!='
7	dpavlin	1
8	dpavlin	3	echo "name [$0 $1] op [$op]"
9	dpavlin	1
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	dpavlin	3	while [ ! "$master" $op "$slave" -o "$slave" == '' ] ; do
16	dpavlin	1	slave="`$psql -p 5002 -c 'select * from po_mjesecima'`"
17			if [ "$oldslave" != "$slave" ]
18			then
19			echo -e "$op SLAVE\n$slave"
20			else
21			echo -n "."
22	dpavlin	3	sleep 2
23	dpavlin	1	fi
24			oldslave="$slave"
25			done
26
27			echo " OK -- master $op slave "