blob: 57e0dde4dc44456f9a9dcb7c6963963e2b43f87c (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
|
#!/bin/bash
## Quick setup for semi-standardized command-line testing
echo This will remove any existing bucardo schema! Proceed?
read yn
if [ $yn != 'y' ]
then
exit
fi
echo Good to go!
## Clear out old databases and users
psql -qc 'drop database if exists bucardo'
psql -qc 'drop database if exists test1'
psql -qc 'drop database if exists test2'
psql -qc 'drop database if exists test3'
psql -qc 'drop user bucardo'
## Install bucardo
./bucardo install --batch
## Create test databases, users, and tables
psql -qc 'create database test1'
psql -d test1 -qc 'create table t1 (id serial primary key, email text)'
psql -d test1 -qc 'create table t2 (id serial primary key, email text)'
psql -d test1 -qc 'create table t3 (id serial primary key, email text)'
psql -d test1 -qc 'create table t4 (id serial primary key, email text)'
psql -qc 'create database test2 template test1'
psql -qc 'create database test3 template test1'
## Tell Bucardo about the databases
./bucardo add db db1 dbname=test1
./bucardo add db db2 dbname=test2
./bucardo add db db3 dbname=test3
## Add in all the tables from test1, put into a herd
./bucardo add all tables herd=myherd
## Add a new table that is not in any herd (or sync)
psql -d test1 -qc 'create table t5 (id serial primary key, email text)'
./bucardo add table t5
## Simple source -> target sync
./bucardo add sync alpha herd=myherd dbs=db1,db2
## Source to source sync
./bucardo add sync beta herd=myherd dbs=db1,db2:source
## Source to source to target sync
./bucardo add sync charlie herd=myherd dbs=db1,db2:source,db3:target
|
