/[rserv]/misc/regress-mm.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 /misc/regress-mm.sh

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

revision 1.3 by dpavlin, Sun Nov 2 21:07:17 2003 UTC revision 1.4 by dpavlin, Sun Nov 2 21:25:56 2003 UTC
# Line 14  createdb slave || exit 1; Line 14  createdb slave || exit 1;
14    
15  $dir/bin/MultiMasterInit -d -v -v master slave || exit 1  $dir/bin/MultiMasterInit -d -v -v master slave || exit 1
16    
17  psql -e -c "create table t1 (i int, t text, d timestamp default 'now');" master  psql -e -c "create table t1 (i int, t text, d timestamp default 'now', uniq serial);" master
18  psql -e -c "create table t1 (i int, t text, d timestamp default 'now');" slave  psql -e -c "create table t1 (i int, t text, d timestamp default 'now', uniq serial);" slave
19    
20    
21  $dir/bin/MasterAddTable -d -v master t1 d || exit 1  $dir/bin/MasterAddTable -d -v master t1 uniq || exit 1
22  $dir/bin/MasterAddTable -d -v --masterserver=1 slave t1 d || exit 1  $dir/bin/MasterAddTable -d -v --masterserver=1 slave t1 uniq || exit 1
23  $dir/bin/SlaveAddTable master t1 d || exit 1  $dir/bin/SlaveAddTable master t1 uniq || exit 1
24  $dir/bin/SlaveAddTable slave t1 d || exit 1  $dir/bin/SlaveAddTable slave t1 uniq || exit 1
25    
26  psql -e -c "insert into t1 values (1, 'one insert master');" master  psql -e -c "insert into t1 values (1, 'one insert master');" master
27  psql -e -c "insert into t1 values (2, 'two insert master');" master  psql -e -c "insert into t1 values (2, 'two insert master');" master
# Line 32  if [ "$1" = "stop" ] ; then Line 32  if [ "$1" = "stop" ] ; then
32  fi  fi
33    
34  $dir/bin/Replicate -d -v --multimaster slave master || exit 1  $dir/bin/Replicate -d -v --multimaster slave master || exit 1
35  #$dir/bin/MasterSync --slaveserver=1 slave `$dir/bin/GetSyncID --noverbose master` || exit 1  $dir/bin/MasterSync --slaveserver=1 slave `$dir/bin/GetSyncID --noverbose master` || exit 1
36  echo "slave -> master over"  echo "slave -> master over"
37    
38  $dir/bin/Replicate -d -v --multimaster master slave || exit 1  $dir/bin/Replicate -d -v --multimaster master slave || exit 1
39  #$dir/bin/MasterSync master `$dir/bin/GetSyncID --noverbose slave` || exit 1  $dir/bin/MasterSync master `$dir/bin/GetSyncID --noverbose slave` || exit 1
40  echo "master -> slave over"  echo "master -> slave over"
41    
42  $dir/bin/Replicate -d -v --multimaster slave master || exit 1  $dir/bin/Replicate -d -v --multimaster slave master || exit 1
43  #$dir/bin/MasterSync --slaveserver=1 slave `$dir/bin/GetSyncID --noverbose master` || exit 1  $dir/bin/MasterSync --slaveserver=1 slave `$dir/bin/GetSyncID --noverbose master` || exit 1
44  echo "slave -> master over"  echo "slave -> master over"
45    
46  psql -e -c "insert into t1 values (3, 'three insert on master');" master  psql -e -c "insert into t1 values (3, 'three insert on master');" master
# Line 53  psql -e -c "update t1 set t='two, update Line 53  psql -e -c "update t1 set t='two, update
53  #psql -e -c "update t1 set t='two, updated on slave' where i=2;" slave  #psql -e -c "update t1 set t='two, updated on slave' where i=2;" slave
54    
55  $dir/bin/Replicate -d -v --multimaster master slave || exit 1  $dir/bin/Replicate -d -v --multimaster master slave || exit 1
56  #$dir/bin/MasterSync master `$dir/bin/GetSyncID --noverbose slave` || exit 1  $dir/bin/MasterSync master `$dir/bin/GetSyncID --noverbose slave` || exit 1
57  echo "master -> slave over"  echo "master -> slave over"
58    
59  $dir/bin/Replicate -d -v --multimaster slave master || exit 1  $dir/bin/Replicate -d -v --multimaster slave master || exit 1
60  #$dir/bin/MasterSync --slaveserver=1 slave `$dir/bin/GetSyncID --noverbose master` || exit 1  $dir/bin/MasterSync --slaveserver=1 slave `$dir/bin/GetSyncID --noverbose master` || exit 1
61  echo "slave -> master over"  echo "slave -> master over"
62    
63  $dir/bin/Replicate -d -v --multimaster master slave || exit 1  $dir/bin/Replicate -d -v --multimaster master slave || exit 1
64  $dir/bin/Replicate -d -v --multimaster slave master || exit 1  $dir/bin/Replicate -d -v --multimaster slave master || exit 1
65    
66    if [ -e "$dir/bin/../pgdiff/pgdiff" ] ; then
67            cd $dir/bin/../pgdiff && ./pgdiff -v master slave
68    fi
69  exit  exit
Legend:
Removed from v.1.3  
changed lines
  Added in v.1.4
  ViewVC Help
Powered by ViewVC 1.1.26