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