rserv/misc/regress.sh

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

dir="../bin"

dropdb master
dropdb slave

createdb master
createdb slave

$dir/MasterInit master
$dir/SlaveInit slave

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

psql -c "create table t1 (i int, t text, d timestamp default text '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 `GetSyncID --noverbose slave`

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 `GetSyncID --noverbose slave`

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