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 **"

dir=/home/dpavlin/private/adsl
$dir/fix_date.pl $dir/200608.txt | $psql -p 5001 -c 'copy spajanja (start_t,stop_t,download,upload,duration,ip) from stdin;'

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! **"
$dir/fix_date.pl $dir/200609.txt | $psql -p 5002 -c 'copy spajanja (start_t,stop_t,download,upload,duration,ip) from stdin;'
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	dir=/home/dpavlin/private/adsl
10	$dir/fix_date.pl $dir/200608.txt \| $psql -p 5001 -c 'copy spajanja (start_t,stop_t,download,upload,duration,ip) from stdin;'
11
12	echo " after new data "
13
14	master="`$psql -p 5001 -c 'select * from po_mjesecima'`"
15	echo -e "## MASTER\n$master"
16	slave=''
17	while [ "$master" != "$slave" ] ; do
18	slave="`$psql -p 5002 -c 'select * from po_mjesecima'`"
19	echo -e "!! SLAVE\n$slave"
20	sleep 2
21	done
22
23	echo " OK "
24
25	echo " following SHOULD RETURN ERROR! "
26	$dir/fix_date.pl $dir/200609.txt \| $psql -p 5002 -c 'copy spajanja (start_t,stop_t,download,upload,duration,ip) from stdin;'