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 |