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

Annotation of /misc/regress-casc.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
CVS Tags: HEAD
Changes since 1.2: +17 -17 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     # This script will setup replication like:
6     # master -> slave1
7     # slave1 -> slave2
8    
9     dir="`dirname $0`/../"
10    
11     dropdb master
12     dropdb slave1
13     dropdb slave2
14    
15     createdb master || exit 1;
16     createdb slave1 || exit 1;
17     createdb slave2 || exit 1;
18    
19 dpavlin 1.2 $dir/bin/MasterInit master || exit 1
20     $dir/bin/SlaveInit master slave1 || exit 1
21     $dir/bin/MasterInit slave1 || exit 1
22     $dir/bin/SlaveInit slave1 slave2 || exit 1
23 dpavlin 1.1
24 dpavlin 1.3 psql -e -c "create table t1 (i int, t text, d timestamp default 'now');" master
25 dpavlin 1.2 $dir/bin/MasterAddTable master t1 d || exit 1
26 dpavlin 1.1
27 dpavlin 1.3 psql -e -c "create table t1 (i int, t text, d timestamp default 'now');" slave1
28 dpavlin 1.2 $dir/bin/SlaveAddTable slave1 t1 d || exit 1
29     $dir/bin/MasterAddTable slave1 t1 d || exit 1
30 dpavlin 1.3 psql -e -c "create table t1 (i int, t text, d timestamp default 'now');" slave2
31 dpavlin 1.2 $dir/bin/SlaveAddTable slave2 t1 d || exit 1
32 dpavlin 1.1
33 dpavlin 1.3 psql -e -c "insert into t1 values (1, 'one');" master
34     psql -e -c "insert into t1 values (2, 'two');" master
35 dpavlin 1.1
36 dpavlin 1.3 $dir/bin/Replicate -v -d master slave1 || exit 1
37 dpavlin 1.2 $dir/bin/MasterSync master `$dir/bin/GetSyncID --noverbose slave1` || exit 1
38 dpavlin 1.3 $dir/bin/Replicate -v -d slave1 slave2 || exit 1
39 dpavlin 1.2 $dir/bin/MasterSync slave1 `$dir/bin/GetSyncID --noverbose slave2` || exit 1
40 dpavlin 1.1
41 dpavlin 1.3 psql -e -c "delete from t1 where i=1;" master
42     psql -e -c "update t1 set t='two, updated' where i=2;" master
43     psql -e -c "insert into t1 values (3, 'three');" master
44     psql -e -c "insert into t1 values (4, 'four');" master
45 dpavlin 1.1
46 dpavlin 1.2 $dir/bin/Replicate master slave1 || exit 1
47     $dir/bin/MasterSync master `$dir/bin/GetSyncID --noverbose slave1` || exit 1
48     $dir/bin/Replicate slave1 slave2 || exit 1
49     $dir/bin/MasterSync slave1 `$dir/bin/GetSyncID --noverbose slave2` || exit 1
50 dpavlin 1.1
51 dpavlin 1.3 psql -e -c "insert into t1 values (1, 'one-insert2');" master
52     psql -e -c "delete from t1 where i=3;" master
53     psql -e -c "insert into t1 values (3, 'three-insert2');" master
54     psql -e -c "update t1 set t='four, updated' where i=4;" master
55 dpavlin 1.1
56 dpavlin 1.3 $dir/bin/Replicate -v -d master slave1 || exit 1
57 dpavlin 1.2 $dir/bin/MasterSync master `$dir/bin/GetSyncID --noverbose slave1` || exit 1
58 dpavlin 1.3 $dir/bin/Replicate -v -d slave1 slave2 || exit 1
59 dpavlin 1.2 $dir/bin/MasterSync slave1 `$dir/bin/GetSyncID --noverbose slave2` || exit 1
60 dpavlin 1.1
61     if [ -e "$dir/bin/../pgdiff/pgdiff" ] ; then
62     cd $dir/bin/../pgdiff
63     ./pgdiff -v master slave1
64     ./pgdiff -v master slave2
65     fi
66    
67     exit
  ViewVC Help
Powered by ViewVC 1.1.26