rserv/misc/regress.sh

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

dropdb master
dropdb slave

createdb master
createdb slave

MasterInit master
SlaveInit slave

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

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

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

Replicate master slave
MasterSync master `GetSyncID --noverbose slave`

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

Replicate master slave
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			dropdb master
6			dropdb slave
7
8			createdb master
9			createdb slave
10
11			MasterInit master
12			SlaveInit slave
13
14			psql -c "create table t1 (i int, t text, d timestamp default text 'now');" master
15			MasterAddTable master t1 d
16
17			psql -c "create table t1 (i int, t text, d timestamp default text 'now');" slave
18			SlaveAddTable slave t1 d
19
20			psql -c "insert into t1 values (1, 'one');" master
21			psql -c "insert into t1 values (2, 'two');" master
22
23			Replicate master slave
24			MasterSync master `GetSyncID --noverbose slave`
25
26			psql -c "insert into t1 values (3, 'three');" master
27			psql -c "insert into t1 values (4, 'four');" master
28
29			Replicate master slave
30			MasterSync master `GetSyncID --noverbose slave`
31
32			exit