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

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

revision 1.1 by dpavlin, Wed Oct 29 17:26:59 2003 UTC revision 1.3 by dpavlin, Wed Oct 29 18:17:59 2003 UTC
# Line 2  Line 2 
2  # rserv regression test script  # rserv regression test script
3  # (c) 2000 Thomas Lockhart, PostgreSQL Inc.  # (c) 2000 Thomas Lockhart, PostgreSQL Inc.
4    
5  dir="`dirname $0`/../bin"  dir="`dirname $0`/../"
6    
7  dropdb master  dropdb master
8  dropdb slave1  dropdb slave1
# Line 12  createdb master || exit 1; Line 12  createdb master || exit 1;
12  createdb slave1 || exit 1;  createdb slave1 || exit 1;
13  createdb slave2 || exit 1;  createdb slave2 || exit 1;
14    
15  $dir/MasterInit master  $dir/bin/MasterInit master
16  $dir/SlaveInit master slave1  $dir/bin/SlaveInit master slave1
17  $dir/SlaveInit master slave2  $dir/bin/SlaveInit master slave2
18    
19  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
20  $dir/MasterAddTable master t1 d  $dir/bin/MasterAddTable master t1 d
21    
22  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
23  $dir/SlaveAddTable slave1 t1 d  $dir/bin/SlaveAddTable slave1 t1 d
24  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
25  $dir/SlaveAddTable slave2 t1 d  $dir/bin/SlaveAddTable slave2 t1 d
26    
27  psql -c "insert into t1 values (1, 'one');" master  psql -c "insert into t1 values (1, 'one');" master
28  psql -c "insert into t1 values (2, 'two');" master  psql -c "insert into t1 values (2, 'two');" master
29    
30  $dir/Replicate master slave1  $dir/bin/Replicate master slave1
31  $dir/MasterSync master `$dir/GetSyncID --noverbose slave1`  $dir/bin/MasterSync master `$dir/bin/GetSyncID --noverbose slave1`
32  $dir/Replicate master slave2  $dir/bin/Replicate master slave2
33  $dir/MasterSync master `$dir/GetSyncID --noverbose slave2`  $dir/bin/MasterSync master `$dir/bin/GetSyncID --noverbose slave2`
34    
35    psql -c "delete from t1 where i=1;" master
36    psql -c "update t1 set t='two, updated' where i=2;" master
37  psql -c "insert into t1 values (3, 'three');" master  psql -c "insert into t1 values (3, 'three');" master
38  psql -c "insert into t1 values (4, 'four');" master  psql -c "insert into t1 values (4, 'four');" master
39    
40  $dir/Replicate master slave1  $dir/bin/Replicate master slave1
41  $dir/MasterSync master `$dir/GetSyncID --noverbose slave1`  $dir/bin/MasterSync master `$dir/bin/GetSyncID --noverbose slave1`
42  $dir/Replicate master slave2  $dir/bin/Replicate master slave2
43  $dir/MasterSync master `$dir/GetSyncID --noverbose slave2`  $dir/bin/MasterSync master `$dir/bin/GetSyncID --noverbose slave2`
44    
45    psql -c "insert into t1 values (1, 'one-insert2');" master
46    psql -c "delete from t1 where i=3;" master
47    psql -c "insert into t1 values (3, 'three-insert2');" master
48    psql -c "update t1 set t='four, updated' where i=4;" master
49    
50    $dir/bin/Replicate master slave1
51    $dir/bin/MasterSync master `$dir/bin/GetSyncID --noverbose slave1`
52    $dir/bin/Replicate master slave2
53    $dir/bin/MasterSync master `$dir/bin/GetSyncID --noverbose slave2`
54    
55  if [ -e "$dir/bin/../pgdiff/pgdiff" ] ; then  if [ -e "$dir/bin/../pgdiff/pgdiff" ] ; then
56          cd $dir/bin/../pgdiff/ && ./pgdiff -v master slave          cd $dir/bin/../pgdiff
57            ./pgdiff -v master slave1
58            ./pgdiff -v master slave2
59  fi  fi
60    
61  exit  exit
Legend:
Removed from v.1.1  
changed lines
  Added in v.1.3
  ViewVC Help
Powered by ViewVC 1.1.26