slony-test/adsl/04_test_replication.sh

echo "** before new data **"

psql="sudo -u postgres psql adsl"
$psql -p 5001 -c 'select * from po_mjesecima'
$psql -p 5002 -c 'select * from po_mjesecima'

echo "** insert new data in master **"

$psql -p 5001 -c 'copy spajanja (start_t,stop_t,download,upload,duration,ip) from stdin;' < data/200608.txt

echo "** after new data **"

master="`$psql -p 5001 -c 'select * from po_mjesecima'`"
echo -e "## MASTER\n$master"
slave=''
while [ "$master" != "$slave" ] ; do
        slave="`$psql -p 5002 -c 'select * from po_mjesecima'`"
        echo -e "!! SLAVE\n$slave"
        sleep 2
done

echo "** OK **"

echo "** following SHOULD RETURN ERROR! **"
$psql -p 5002 -c 'copy spajanja (start_t,stop_t,download,upload,duration,ip) from stdin;' < data/200609.txt
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