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

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

revision 1.1.1.1 by dpavlin, Thu Dec 21 14:20:06 2000 UTC revision 1.7 by dpavlin, Sun Nov 2 13:19:24 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`/../"
6    
7  dropdb master  dropdb master
8  dropdb slave  dropdb slave
9    
10  createdb master  createdb master || exit 1;
11  createdb slave  createdb slave || exit 1;
12    
13  MasterInit master  $dir/bin/MasterInit master
14  SlaveInit slave  $dir/bin/SlaveInit master slave
15    
16  psql -c "create table t1 (i int, t text, d timestamp default text 'now');" master  psql -c "create table t1 (i int, t text, d timestamp default 'now');" master
17  MasterAddTable master t1 d  $dir/bin/MasterAddTable master t1 d || exit 1
18    
19  psql -c "create table t1 (i int, t text, d timestamp default text 'now');" slave  psql -c "create table t1 (i int, t text, d timestamp default 'now');" slave
20  SlaveAddTable slave t1 d  $dir/bin/SlaveAddTable slave t1 d || exit 1
21    
22  psql -c "insert into t1 values (1, 'one');" master  psql -c "insert into t1 values (1, 'one');" master
23  psql -c "insert into t1 values (2, 'two');" master  psql -c "insert into t1 values (2, 'two');" master
24    
25  Replicate master slave  $dir/bin/Replicate master slave || exit 1
26  MasterSync master `GetSyncID --noverbose slave`  $dir/bin/MasterSync master `$dir/bin/GetSyncID --noverbose slave` || exit 1
27    
28    psql -c "delete from t1 where i=1;" master
29    psql -c "update t1 set t='two, updated' where i=2;" master
30  psql -c "insert into t1 values (3, 'three');" master  psql -c "insert into t1 values (3, 'three');" master
31  psql -c "insert into t1 values (4, 'four');" master  psql -c "insert into t1 values (4, 'four');" master
32    
33  Replicate master slave  $dir/bin/Replicate master slave || exit 1
34  MasterSync master `GetSyncID --noverbose slave`  $dir/bin/MasterSync master `$dir/bin/GetSyncID --noverbose slave` || exit 1
35    
36    psql -c "insert into t1 values (1, 'one-insert2');" master
37    psql -c "delete from t1 where i=3;" master
38    psql -c "insert into t1 values (3, 'three-insert2');" master
39    psql -c "update t1 set t='four, updated' where i=4;" master
40    
41    $dir/bin/Replicate master slave || exit 1
42    $dir/bin/MasterSync master `$dir/bin/GetSyncID --noverbose slave` || exit 1
43    
44    if [ -e "$dir/bin/../pgdiff/pgdiff" ] ; then
45            cd $dir/bin/../pgdiff/ && ./pgdiff -v master slave
46    fi
47    
48  exit  exit
Legend:
Removed from v.1.1.1.1  
changed lines
  Added in v.1.7
  ViewVC Help
Powered by ViewVC 1.1.26