/[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

Annotation of /misc/regress-mm.sh

Parent Directory Parent Directory | Revision Log Revision Log

Revision 1.3 - (hide annotations)
Sun Nov 2 21:07:17 2003 UTC (20 years, 5 months ago) by dpavlin
Branch: MAIN
Changes since 1.2: +34 -22 lines
File MIME type: application/x-sh 
first multi-master version which pass regression tests (that doesn't
mean working; tests might just be too little...)
renamed multiplemaster to simple multimaster
1 dpavlin 1.1 # regress.sh
2     # rserv regression test script
3     # (c) 2000 Thomas Lockhart, PostgreSQL Inc.
4     #
5     # modified for multiple-masters by Dobrica Pavlinusic <dpavlin@rot13.org>
6    
7     dir="`dirname $0`/../"
8    
9     dropdb master
10     dropdb slave
11    
12     createdb master || exit 1;
13     createdb slave || exit 1;
14    
15 dpavlin 1.3 $dir/bin/MultiMasterInit -d -v -v master slave || exit 1
16 dpavlin 1.1
17 dpavlin 1.3 psql -e -c "create table t1 (i int, t text, d timestamp default 'now');" master
18     psql -e -c "create table t1 (i int, t text, d timestamp default 'now');" slave
19 dpavlin 1.1
20 dpavlin 1.3
21     $dir/bin/MasterAddTable -d -v master t1 d || exit 1
22     $dir/bin/MasterAddTable -d -v --masterserver=1 slave t1 d || exit 1
23 dpavlin 1.2 $dir/bin/SlaveAddTable master t1 d || exit 1
24     $dir/bin/SlaveAddTable slave t1 d || exit 1
25 dpavlin 1.1
26 dpavlin 1.3 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
28     psql -e -c "insert into t1 values (101, '101 insert on slave');" slave
29    
30     if [ "$1" = "stop" ] ; then
31     exit
32     fi
33    
34     $dir/bin/Replicate -d -v --multimaster slave master || exit 1
35     #$dir/bin/MasterSync --slaveserver=1 slave `$dir/bin/GetSyncID --noverbose master` || exit 1
36     echo "slave -> master over"
37 dpavlin 1.1
38 dpavlin 1.3 $dir/bin/Replicate -d -v --multimaster master slave || exit 1
39     #$dir/bin/MasterSync master `$dir/bin/GetSyncID --noverbose slave` || exit 1
40 dpavlin 1.1 echo "master -> slave over"
41    
42 dpavlin 1.3 $dir/bin/Replicate -d -v --multimaster slave master || exit 1
43     #$dir/bin/MasterSync --slaveserver=1 slave `$dir/bin/GetSyncID --noverbose master` || exit 1
44 dpavlin 1.1 echo "slave -> master over"
45    
46 dpavlin 1.3 psql -e -c "insert into t1 values (3, 'three insert on master');" master
47     psql -e -c "insert into t1 values (4, 'four insert on slave');" master
48     psql -e -c "delete from t1 where i=1;" master
49     psql -e -c "update t1 set t='two, updated on master' where i=2;" master
50 dpavlin 1.1
51     # conflicts
52 dpavlin 1.3 #psql -e -c "delete from t1 where i=1;" slave
53     #psql -e -c "update t1 set t='two, updated on slave' where i=2;" slave
54 dpavlin 1.1
55 dpavlin 1.3 $dir/bin/Replicate -d -v --multimaster master slave || exit 1
56     #$dir/bin/MasterSync master `$dir/bin/GetSyncID --noverbose slave` || exit 1
57 dpavlin 1.1 echo "master -> slave over"
58    
59 dpavlin 1.3 $dir/bin/Replicate -d -v --multimaster slave master || exit 1
60     #$dir/bin/MasterSync --slaveserver=1 slave `$dir/bin/GetSyncID --noverbose master` || exit 1
61 dpavlin 1.1 echo "slave -> master over"
62 dpavlin 1.3
63     $dir/bin/Replicate -d -v --multimaster master slave || exit 1
64     $dir/bin/Replicate -d -v --multimaster slave master || exit 1
65 dpavlin 1.1
66     exit
  ViewVC Help
Powered by ViewVC 1.1.26