Contents of /bin/InitRservTest

#!/bin/sh
# InitRservTest
# erServer demonstration implementation
# (c) 2000 Vadim Mikheev, PostgreSQL Inc.

[ -n "$RSERV_PERL" ] || RSERV_PERL=/usr/share/postgresql/contrib
[ -n "$RSERV_SQL" ] || RSERV_SQL=/usr/share/postgresql/contrib
[ -n "$RSERV_BIN" ] || RSERV_BIN=/usr/lib/postgresql/bin
export RSERV_PERL
export RSERV_SQL
export RSERV_BIN

pargs=

while [[ $1 == -* ]]; do
    case "$1" in
        --user)
            shift
            pargs="$pargs -U $1"
            ;;
        --host)
            shift
            pargs="$pargs -h $1"
            ;;
        *)
            echo "Usage: $0 --user name --host name masterdb slavedb"
            exit 1
            ;;
    esac
    shift
done

masterdb=$1
slavedb=$2

[ "${masterdb}" != "" ] || masterdb=master
[ "${slavedb}" != "" ] || slavedb=slave

echo "Master -> $masterdb"
echo "Slave  -> $slavedb"

############################################################################

fill()
{
        table="create table test (i text, k int, l int);
copy test from stdin;
Line: 1 1       1
Line: 2 2       2
Line: 3 3       3
Line: 4 4       4
Line: 5 5       5
Line: 6 6       6
Line: 7 7       7
Line: 8 8       8
Line: 9 9       9
Line: 10        10      10
Line: 11        11      11
Line: 12        12      12
Line: 13        13      13
Line: 14        14      14
Line: 15        15      15
Line: 16        16      16
Line: 17        17      17
Line: 18        18      18
Line: 19        19      19
Line: 20        20      20
Line: 21        21      21
Line: 22        22      22
Line: 23        23      23
Line: 24        24      24
Line: 25        25      25
Line: 26        26      26
Line: 27        27      27
Line: 28        28      28
Line: 29        29      29
Line: 30        30      30
Line: 31        31      31
Line: 32        32      32
Line: 33        33      33
Line: 34        34      34
Line: 35        35      35
Line: 36        36      36
Line: 37        37      37
Line: 38        38      38
Line: 39        39      39
Line: 40        40      40
Line: 41        41      41
Line: 42        42      42
Line: 43        43      43
Line: 44        44      44
Line: 45        45      45
Line: 46        46      46
Line: 47        47      47
Line: 48        48      48
Line: 49        49      49
Line: 50        50      50
Line: 51        51      51
Line: 52        52      52
Line: 53        53      53
Line: 54        54      54
Line: 55        55      55
Line: 56        56      56
Line: 57        57      57
Line: 58        58      58
Line: 59        59      59
Line: 60        60      60
Line: 61        61      61
Line: 62        62      62
Line: 63        63      63
Line: 64        64      64
Line: 65        65      65
Line: 66        66      66
Line: 67        67      67
Line: 68        68      68
Line: 69        69      69
Line: 70        70      70
Line: 71        71      71
Line: 72        72      72
Line: 73        73      73
Line: 74        74      74
Line: 75        75      75
Line: 76        76      76
Line: 77        77      77
Line: 78        78      78
Line: 79        79      79
Line: 80        80      80
Line: 81        81      81
Line: 82        82      82
Line: 83        83      83
Line: 84        84      84
Line: 85        85      85
Line: 86        86      86
Line: 87        87      87
Line: 88        88      88
Line: 89        89      89
Line: 90        90      90
Line: 91        91      91
Line: 92        92      92
Line: 93        93      93
Line: 94        94      94
Line: 95        95      95
Line: 96        96      96
Line: 97        97      97
Line: 98        98      98
Line: 99        99      99
Line: 100       100     100
\\.";
        echo "$table" | psql $pargs $1 || exit
        if [ "$1" = "$masterdb" ]
        then
                rm -rf __tmpf__
                psql $pargs -c "select * into table testoid from test" $1 || exit
                psql $pargs -c "copy testoid with oids to '`pwd`/__tmpf__'" $1 || exit
                psql $pargs -c "select * into table teststr from test" $1 || exit
        else
                psql $pargs -c "select * into table testoid from test where k < 0" $1 || exit
                psql $pargs -c "copy testoid with oids from '`pwd`/__tmpf__'" $1 || exit
                psql $pargs -c "select * into table teststr from test" $1 || exit
                rm -rf __tmpf__
        fi
        psql $pargs -c "create unique index i_test on test (k)" $1 || exit
        psql $pargs -c "create unique index i_testoid on testoid (oid)" $1 || exit
        psql $pargs -c "create unique index i_teststr on teststr (i)" $1 || exit
        psql $pargs -c vacuum $1 || exit
}

############################################################################

echo
echo
echo '                            ATTENTION'
echo
echo This script will destroy databases with names MASTER and SLAVE
echo
echo -n "Are you going to continue ? [Y/N] "

read answ

case $answ in
    Y*|y*)
        ;;
    *)
        exit
        ;;
esac

echo
echo

sql="drop database $masterdb"
echo $sql
psql $pargs -c "$sql" template1
sql="create database $masterdb"
echo $sql
psql $pargs -c "$sql" template1 || exit

echo Setup master system
psql $pargs $masterdb < $RSERV_SQL/master.sql || exit

echo Wait for template1 to become available...
sleep 1

sql="drop database $slavedb"
echo $sql
psql $pargs -c "$sql" template1
sql="create database $slavedb"
echo $sql
psql $pargs -c "$sql" template1 || exit

echo Setup slave system
psql $pargs $slavedb < $RSERV_SQL/slave.sql || exit

echo Create and fill test, testoid and teststr tables in master db
fill $masterdb
echo
echo Register test, testoid and teststr tables for replication on master
echo
$RSERV_BIN/MasterAddTable $masterdb test k
$RSERV_BIN/MasterAddTable $masterdb testoid oid
$RSERV_BIN/MasterAddTable $masterdb teststr i

echo Create and fill test, testoid and teststr tables in slave db
fill $slavedb
echo
echo Register test, testoid and teststr tables for replication on slave
echo
$RSERV_BIN/SlaveAddTable $slavedb test k
$RSERV_BIN/SlaveAddTable $slavedb testoid oid
$RSERV_BIN/SlaveAddTable $slavedb teststr i

echo 
echo 
echo 
echo 
echo 
echo 
echo 
echo 
echo "            Now make changes in $masterdb db and run"
echo 
echo "                Replicate $masterdb $slavedb"
echo 
echo "            to replicate the master on the slave."
echo 
echo "            You may also use the RservTest tcl utility"
echo "            to demonstrate this functionality."
echo 
echo 
echo 
echo 
echo 
echo 
echo 
echo 

exit

############################################################################
1	#!/bin/sh
2	# InitRservTest
3	# erServer demonstration implementation
4	# (c) 2000 Vadim Mikheev, PostgreSQL Inc.
5
6	[ -n "$RSERV_PERL" ] \|\| RSERV_PERL=/usr/share/postgresql/contrib
7	[ -n "$RSERV_SQL" ] \|\| RSERV_SQL=/usr/share/postgresql/contrib
8	[ -n "$RSERV_BIN" ] \|\| RSERV_BIN=/usr/lib/postgresql/bin
9	export RSERV_PERL
10	export RSERV_SQL
11	export RSERV_BIN
12
13	pargs=
14
15	while [[ $1 == -* ]]; do
16	case "$1" in
17	--user)
18	shift
19	pargs="$pargs -U $1"
20	;;
21	--host)
22	shift
23	pargs="$pargs -h $1"
24	;;
25	*)
26	echo "Usage: $0 --user name --host name masterdb slavedb"
27	exit 1
28	;;
29	esac
30	shift
31	done
32
33	masterdb=$1
34	slavedb=$2
35
36	[ "${masterdb}" != "" ] \|\| masterdb=master
37	[ "${slavedb}" != "" ] \|\| slavedb=slave
38
39	echo "Master -> $masterdb"
40	echo "Slave -> $slavedb"
41
42	############################################################################
43
44	fill()
45	{
46	table="create table test (i text, k int, l int);
47	copy test from stdin;
48	Line: 1 1 1
49	Line: 2 2 2
50	Line: 3 3 3
51	Line: 4 4 4
52	Line: 5 5 5
53	Line: 6 6 6
54	Line: 7 7 7
55	Line: 8 8 8
56	Line: 9 9 9
57	Line: 10 10 10
58	Line: 11 11 11
59	Line: 12 12 12
60	Line: 13 13 13
61	Line: 14 14 14
62	Line: 15 15 15
63	Line: 16 16 16
64	Line: 17 17 17
65	Line: 18 18 18
66	Line: 19 19 19
67	Line: 20 20 20
68	Line: 21 21 21
69	Line: 22 22 22
70	Line: 23 23 23
71	Line: 24 24 24
72	Line: 25 25 25
73	Line: 26 26 26
74	Line: 27 27 27
75	Line: 28 28 28
76	Line: 29 29 29
77	Line: 30 30 30
78	Line: 31 31 31
79	Line: 32 32 32
80	Line: 33 33 33
81	Line: 34 34 34
82	Line: 35 35 35
83	Line: 36 36 36
84	Line: 37 37 37
85	Line: 38 38 38
86	Line: 39 39 39
87	Line: 40 40 40
88	Line: 41 41 41
89	Line: 42 42 42
90	Line: 43 43 43
91	Line: 44 44 44
92	Line: 45 45 45
93	Line: 46 46 46
94	Line: 47 47 47
95	Line: 48 48 48
96	Line: 49 49 49
97	Line: 50 50 50
98	Line: 51 51 51
99	Line: 52 52 52
100	Line: 53 53 53
101	Line: 54 54 54
102	Line: 55 55 55
103	Line: 56 56 56
104	Line: 57 57 57
105	Line: 58 58 58
106	Line: 59 59 59
107	Line: 60 60 60
108	Line: 61 61 61
109	Line: 62 62 62
110	Line: 63 63 63
111	Line: 64 64 64
112	Line: 65 65 65
113	Line: 66 66 66
114	Line: 67 67 67
115	Line: 68 68 68
116	Line: 69 69 69
117	Line: 70 70 70
118	Line: 71 71 71
119	Line: 72 72 72
120	Line: 73 73 73
121	Line: 74 74 74
122	Line: 75 75 75
123	Line: 76 76 76
124	Line: 77 77 77
125	Line: 78 78 78
126	Line: 79 79 79
127	Line: 80 80 80
128	Line: 81 81 81
129	Line: 82 82 82
130	Line: 83 83 83
131	Line: 84 84 84
132	Line: 85 85 85
133	Line: 86 86 86
134	Line: 87 87 87
135	Line: 88 88 88
136	Line: 89 89 89
137	Line: 90 90 90
138	Line: 91 91 91
139	Line: 92 92 92
140	Line: 93 93 93
141	Line: 94 94 94
142	Line: 95 95 95
143	Line: 96 96 96
144	Line: 97 97 97
145	Line: 98 98 98
146	Line: 99 99 99
147	Line: 100 100 100
148	\\.";
149	echo "$table" \| psql $pargs $1 \|\| exit
150	if [ "$1" = "$masterdb" ]
151	then
152	rm -rf __tmpf__
153	psql $pargs -c "select * into table testoid from test" $1 \|\| exit
154	psql $pargs -c "copy testoid with oids to '`pwd`/__tmpf__'" $1 \|\| exit
155	psql $pargs -c "select * into table teststr from test" $1 \|\| exit
156	else
157	psql $pargs -c "select * into table testoid from test where k < 0" $1 \|\| exit
158	psql $pargs -c "copy testoid with oids from '`pwd`/__tmpf__'" $1 \|\| exit
159	psql $pargs -c "select * into table teststr from test" $1 \|\| exit
160	rm -rf __tmpf__
161	fi
162	psql $pargs -c "create unique index i_test on test (k)" $1 \|\| exit
163	psql $pargs -c "create unique index i_testoid on testoid (oid)" $1 \|\| exit
164	psql $pargs -c "create unique index i_teststr on teststr (i)" $1 \|\| exit
165	psql $pargs -c vacuum $1 \|\| exit
166	}
167
168	############################################################################
169
170	echo
171	echo
172	echo ' ATTENTION'
173	echo
174	echo This script will destroy databases with names MASTER and SLAVE
175	echo
176	echo -n "Are you going to continue ? [Y/N] "
177
178	read answ
179
180	case $answ in
181	Y\|y)
182	;;
183	*)
184	exit
185	;;
186	esac
187
188	echo
189	echo
190
191	sql="drop database $masterdb"
192	echo $sql
193	psql $pargs -c "$sql" template1
194	sql="create database $masterdb"
195	echo $sql
196	psql $pargs -c "$sql" template1 \|\| exit
197
198	echo Setup master system
199	psql $pargs $masterdb < $RSERV_SQL/master.sql \|\| exit
200
201	echo Wait for template1 to become available...
202	sleep 1
203
204	sql="drop database $slavedb"
205	echo $sql
206	psql $pargs -c "$sql" template1
207	sql="create database $slavedb"
208	echo $sql
209	psql $pargs -c "$sql" template1 \|\| exit
210
211	echo Setup slave system
212	psql $pargs $slavedb < $RSERV_SQL/slave.sql \|\| exit
213
214	echo Create and fill test, testoid and teststr tables in master db
215	fill $masterdb
216	echo
217	echo Register test, testoid and teststr tables for replication on master
218	echo
219	$RSERV_BIN/MasterAddTable $masterdb test k
220	$RSERV_BIN/MasterAddTable $masterdb testoid oid
221	$RSERV_BIN/MasterAddTable $masterdb teststr i
222
223	echo Create and fill test, testoid and teststr tables in slave db
224	fill $slavedb
225	echo
226	echo Register test, testoid and teststr tables for replication on slave
227	echo
228	$RSERV_BIN/SlaveAddTable $slavedb test k
229	$RSERV_BIN/SlaveAddTable $slavedb testoid oid
230	$RSERV_BIN/SlaveAddTable $slavedb teststr i
231
232	echo
233	echo
234	echo
235	echo
236	echo
237	echo
238	echo
239	echo
240	echo " Now make changes in $masterdb db and run"
241	echo
242	echo " Replicate $masterdb $slavedb"
243	echo
244	echo " to replicate the master on the slave."
245	echo
246	echo " You may also use the RservTest tcl utility"
247	echo " to demonstrate this functionality."
248	echo
249	echo
250	echo
251	echo
252	echo
253	echo
254	echo
255	echo
256
257	exit
258
259	############################################################################