rserv/misc/regress.sh

# regress.sh
# rserv regression test script
# (c) 2000 Thomas Lockhart, PostgreSQL Inc.

dir="`dirname $0`/../bin"

dropdb master
dropdb slave

createdb master
createdb slave

$dir/MasterInit master
$dir/SlaveInit master slave

psql -c "create table t1 (i int, t text, d timestamp default 'now');" master
$dir/MasterAddTable master t1 d

psql -c "create table t1 (i int, t text, d timestamp default 'now');" slave
$dir/SlaveAddTable slave t1 d

psql -c "insert into t1 values (1, 'one');" master
psql -c "insert into t1 values (2, 'two');" master

$dir/Replicate master slave
$dir/MasterSync master `$dir/GetSyncID --noverbose slave`

psql -c "delete from t1 where i=1;" master
psql -c "update t1 set t='two, updated' where i=2;" master
psql -c "insert into t1 values (3, 'three');" master
psql -c "insert into t1 values (4, 'four');" master

$dir/Replicate master slave
$dir/MasterSync master `$dir/GetSyncID --noverbose slave`

psql -c "insert into t1 values (1, 'one-insert2');" master
psql -c "delete from t1 where i=3;" master
psql -c "insert into t1 values (3, 'three-insert2');" master
psql -c "update t1 set t='four, updated' where i=4;" master

$dir/Replicate master slave
$dir/MasterSync master `$dir/GetSyncID --noverbose slave`

exit
1	# regress.sh
2	# rserv regression test script
3	# (c) 2000 Thomas Lockhart, PostgreSQL Inc.
4
5	dir="`dirname $0`/../bin"
6
7	dropdb master
8	dropdb slave
9
10	createdb master
11	createdb slave
12
13	$dir/MasterInit master
14	$dir/SlaveInit master slave
15
16	psql -c "create table t1 (i int, t text, d timestamp default 'now');" master
17	$dir/MasterAddTable master t1 d
18
19	psql -c "create table t1 (i int, t text, d timestamp default 'now');" slave
20	$dir/SlaveAddTable slave t1 d
21
22	psql -c "insert into t1 values (1, 'one');" master
23	psql -c "insert into t1 values (2, 'two');" master
24
25	$dir/Replicate master slave
26	$dir/MasterSync master `$dir/GetSyncID --noverbose slave`
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
31	psql -c "insert into t1 values (4, 'four');" master
32
33	$dir/Replicate master slave
34	$dir/MasterSync master `$dir/GetSyncID --noverbose slave`
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/Replicate master slave
42	$dir/MasterSync master `$dir/GetSyncID --noverbose slave`
43
44	exit