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	dpavlin	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	dpavlin	7	$psql -p 5001 -c 'copy spajanja (start_t,stop_t,download,upload,duration,ip) from stdin;' < data/200608.txt
10	dpavlin	1
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	dpavlin	7	$psql -p 5002 -c 'copy spajanja (start_t,stop_t,download,upload,duration,ip) from stdin;' < data/200609.txt