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

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

revision 1.1 by dpavlin, Sun Nov 2 11:30:35 2003 UTC revision 1.2 by dpavlin, Sun Nov 2 13:19:24 2003 UTC
# Line 16  createdb master || exit 1; Line 16  createdb master || exit 1;
16  createdb slave1 || exit 1;  createdb slave1 || exit 1;
17  createdb slave2 || exit 1;  createdb slave2 || exit 1;
18    
19  $dir/bin/MasterInit master  $dir/bin/MasterInit master || exit 1
20  $dir/bin/SlaveInit master slave1  $dir/bin/SlaveInit master slave1 || exit 1
21  $dir/bin/MasterInit slave1  $dir/bin/MasterInit slave1 || exit 1
22  $dir/bin/SlaveInit slave1 slave2  $dir/bin/SlaveInit slave1 slave2 || exit 1
23    
24  psql -c "create table t1 (i int, t text, d timestamp default 'now');" master  psql -c "create table t1 (i int, t text, d timestamp default 'now');" master
25  $dir/bin/MasterAddTable master t1 d  $dir/bin/MasterAddTable master t1 d || exit 1
26    
27  psql -c "create table t1 (i int, t text, d timestamp default 'now');" slave1  psql -c "create table t1 (i int, t text, d timestamp default 'now');" slave1
28  $dir/bin/SlaveAddTable slave1 t1 d  $dir/bin/SlaveAddTable slave1 t1 d || exit 1
29    $dir/bin/MasterAddTable slave1 t1 d || exit 1
30  psql -c "create table t1 (i int, t text, d timestamp default 'now');" slave2  psql -c "create table t1 (i int, t text, d timestamp default 'now');" slave2
31  $dir/bin/SlaveAddTable slave2 t1 d  $dir/bin/SlaveAddTable slave2 t1 d || exit 1
32    
33  psql -c "insert into t1 values (1, 'one');" master  psql -c "insert into t1 values (1, 'one');" master
34  psql -c "insert into t1 values (2, 'two');" master  psql -c "insert into t1 values (2, 'two');" master
35    
36  $dir/bin/Replicate master slave1  $dir/bin/Replicate -d master slave1 || exit 1
37  $dir/bin/MasterSync master `$dir/bin/GetSyncID --noverbose slave1`  $dir/bin/MasterSync master `$dir/bin/GetSyncID --noverbose slave1` || exit 1
38  $dir/bin/Replicate slave1 slave2  $dir/bin/Replicate -d slave1 slave2 || exit 1
39  $dir/bin/MasterSync slave1 `$dir/bin/GetSyncID --noverbose slave2`  $dir/bin/MasterSync slave1 `$dir/bin/GetSyncID --noverbose slave2` || exit 1
40    
41  psql -c "delete from t1 where i=1;" master  psql -c "delete from t1 where i=1;" master
42  psql -c "update t1 set t='two, updated' where i=2;" master  psql -c "update t1 set t='two, updated' where i=2;" master
43  psql -c "insert into t1 values (3, 'three');" master  psql -c "insert into t1 values (3, 'three');" master
44  psql -c "insert into t1 values (4, 'four');" master  psql -c "insert into t1 values (4, 'four');" master
45    
46  $dir/bin/Replicate master slave1  $dir/bin/Replicate master slave1 || exit 1
47  $dir/bin/MasterSync master `$dir/bin/GetSyncID --noverbose slave1`  $dir/bin/MasterSync master `$dir/bin/GetSyncID --noverbose slave1` || exit 1
48  $dir/bin/Replicate slave1 slave2  $dir/bin/Replicate slave1 slave2 || exit 1
49  $dir/bin/MasterSync slave1 `$dir/bin/GetSyncID --noverbose slave2`  $dir/bin/MasterSync slave1 `$dir/bin/GetSyncID --noverbose slave2` || exit 1
50    
51  psql -c "insert into t1 values (1, 'one-insert2');" master  psql -c "insert into t1 values (1, 'one-insert2');" master
52  psql -c "delete from t1 where i=3;" master  psql -c "delete from t1 where i=3;" master
53  psql -c "insert into t1 values (3, 'three-insert2');" master  psql -c "insert into t1 values (3, 'three-insert2');" master
54  psql -c "update t1 set t='four, updated' where i=4;" master  psql -c "update t1 set t='four, updated' where i=4;" master
55    
56  $dir/bin/Replicate master slave1  $dir/bin/Replicate -d master slave1 || exit 1
57  $dir/bin/MasterSync master `$dir/bin/GetSyncID --noverbose slave1`  $dir/bin/MasterSync master `$dir/bin/GetSyncID --noverbose slave1` || exit 1
58  $dir/bin/Replicate slave1 slave2  $dir/bin/Replicate -d slave1 slave2 || exit 1
59  $dir/bin/MasterSync slave1 `$dir/bin/GetSyncID --noverbose slave2`  $dir/bin/MasterSync slave1 `$dir/bin/GetSyncID --noverbose slave2` || exit 1
60    
61  if [ -e "$dir/bin/../pgdiff/pgdiff" ] ; then  if [ -e "$dir/bin/../pgdiff/pgdiff" ] ; then
62          cd $dir/bin/../pgdiff          cd $dir/bin/../pgdiff
Legend:
Removed from v.1.1  
changed lines
  Added in v.1.2
  ViewVC Help
Powered by ViewVC 1.1.26