1 |
echo "** before new data **" |
2 |
|
3 |
psql="sudo -u postgres psql adsl" |
4 |
$psql -p 5001 -c 'select * from po_mjesecima' |
5 |
$psql -p 5002 -c 'select * from po_mjesecima' |
6 |
|
7 |
echo "** insert new data in master **" |
8 |
|
9 |
$psql -p 5001 -c 'copy spajanja (start_t,stop_t,download,upload,duration,ip) from stdin;' < data/200608.txt |
10 |
|
11 |
echo "** after new data **" |
12 |
|
13 |
master="`$psql -p 5001 -c 'select * from po_mjesecima'`" |
14 |
echo -e "## MASTER\n$master" |
15 |
slave='' |
16 |
while [ "$master" != "$slave" ] ; do |
17 |
slave="`$psql -p 5002 -c 'select * from po_mjesecima'`" |
18 |
echo -e "!! SLAVE\n$slave" |
19 |
sleep 2 |
20 |
done |
21 |
|
22 |
echo "** OK **" |
23 |
|
24 |
echo "** following SHOULD RETURN ERROR! **" |
25 |
$psql -p 5002 -c 'copy spajanja (start_t,stop_t,download,upload,duration,ip) from stdin;' < data/200609.txt |