/[slony-test]/adsl/test_difference.sh
This is repository of my old source code which isn't updated any more. Go to git.rot13.org for current projects!
ViewVC logotype

Diff of /adsl/test_difference.sh

Parent Directory Parent Directory | Revision Log Revision Log | View Patch Patch

revision 1 by dpavlin, Sun Feb 11 21:52:48 2007 UTC revision 5 by dpavlin, Sun Feb 11 22:33:29 2007 UTC
# Line 2  Line 2 
2  #echo "** sync"  #echo "** sync"
3  #slonik_execute_script -c 'select now();' 1 | slonik  #slonik_execute_script -c 'select now();' 1 | slonik
4    
5  op='!='  op='=='
6  echo $0 $1 | grep '_no_' >/dev/null && op='=='  echo $0 $1 | grep 'diff' >/dev/null && op='!='
7    
8  echo "name [$0] op [$op]"  echo "name [$0 $1] op [$op]"
9    
10  psql="sudo -u postgres psql adsl"  psql="sudo -u postgres psql adsl"
11  master="`$psql -p 5001 -c 'select * from po_mjesecima'`"  master="`$psql -p 5001 -c 'select * from po_mjesecima'`"
12  echo -e "## MASTER\n$master"  echo -e "## MASTER\n$master"
13  slave=''  slave=''
14  oldslave=''  oldslave=''
15  while [ "$master" $op "$slave" ] ; do  sleep=1
16    while [ ! "$master" $op "$slave" -o "$slave" == '' ] ; do
17          slave="`$psql -p 5002 -c 'select * from po_mjesecima'`"          slave="`$psql -p 5002 -c 'select * from po_mjesecima'`"
18          if [ "$oldslave" != "$slave" ]          if [ "$oldslave" != "$slave" ]
19          then          then
20                  echo -e "$op SLAVE\n$slave"                  echo -e "$op SLAVE\n$slave"
21          else          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 "."                  echo -n "."
26                    sleep=`expr $sleep \* 2`
27                    sleep $sleep
28                    master="`$psql -p 5001 -c 'select * from po_mjesecima'`"
29          fi          fi
30          oldslave="$slave"          oldslave="$slave"
         sleep 2  
31  done  done
32    
33  echo "** OK -- master $op slave **"  echo "** OK -- master $op slave **"

Legend:
Removed from v.1  
changed lines
  Added in v.5

  ViewVC Help
Powered by ViewVC 1.1.26