rserv/misc/regress-2s.sh

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

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

dropdb master
dropdb slave1
dropdb slave2

createdb master || exit 1;
createdb slave1 || exit 1;
createdb slave2 || exit 1;

$dir/MasterInit master
$dir/SlaveInit master slave1
$dir/SlaveInit master slave2

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');" slave1
$dir/SlaveAddTable slave1 t1 d
psql -c "create table t1 (i int, t text, d timestamp default 'now');" slave2
$dir/SlaveAddTable slave2 t1 d

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

$dir/Replicate master slave1
$dir/MasterSync master `$dir/GetSyncID --noverbose slave1`
$dir/Replicate master slave2
$dir/MasterSync master `$dir/GetSyncID --noverbose slave2`

psql -c "insert into t1 values (3, 'three');" master
psql -c "insert into t1 values (4, 'four');" master

$dir/Replicate master slave1
$dir/MasterSync master `$dir/GetSyncID --noverbose slave1`
$dir/Replicate master slave2
$dir/MasterSync master `$dir/GetSyncID --noverbose slave2`

if [ -e "$dir/bin/../pgdiff/pgdiff" ] ; then
        cd $dir/bin/../pgdiff/ && ./pgdiff -v master slave
fi

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 slave1
9	dropdb slave2
10
11	createdb master \|\| exit 1;
12	createdb slave1 \|\| exit 1;
13	createdb slave2 \|\| exit 1;
14
15	$dir/MasterInit master
16	$dir/SlaveInit master slave1
17	$dir/SlaveInit master slave2
18
19	psql -c "create table t1 (i int, t text, d timestamp default 'now');" master
20	$dir/MasterAddTable master t1 d
21
22	psql -c "create table t1 (i int, t text, d timestamp default 'now');" slave1
23	$dir/SlaveAddTable slave1 t1 d
24	psql -c "create table t1 (i int, t text, d timestamp default 'now');" slave2
25	$dir/SlaveAddTable slave2 t1 d
26
27	psql -c "insert into t1 values (1, 'one');" master
28	psql -c "insert into t1 values (2, 'two');" master
29
30	$dir/Replicate master slave1
31	$dir/MasterSync master `$dir/GetSyncID --noverbose slave1`
32	$dir/Replicate master slave2
33	$dir/MasterSync master `$dir/GetSyncID --noverbose slave2`
34
35	psql -c "insert into t1 values (3, 'three');" master
36	psql -c "insert into t1 values (4, 'four');" master
37
38	$dir/Replicate master slave1
39	$dir/MasterSync master `$dir/GetSyncID --noverbose slave1`
40	$dir/Replicate master slave2
41	$dir/MasterSync master `$dir/GetSyncID --noverbose slave2`
42
43	if [ -e "$dir/bin/../pgdiff/pgdiff" ] ; then
44	cd $dir/bin/../pgdiff/ && ./pgdiff -v master slave
45	fi
46
47	exit