Michael Crozier crozierm
Fri Jan 13 14:02:57 PST 2006
I'm testing rc3 on Solaris 10/sparc with Postgresql 8.1.  test2 does not seem 
to complete, is it supposed to complete?  Did I not wait long enough?


crozierm$ ./run_test.sh test2
test: test2
----------------------------------------------------
$Id: README,v 1.1.2.1 2005/11/30 17:35:24 cbbrowne Exp $

This test sets up a trio of three simple tables, and sets up
replication from node 1 to node 2 which then replicates to node 3.

It then fails over to node 3 and sees how things turn out.
----------------------------------------------------
creating origin DB: postgres -h localhost -U postgres -p 5432 slonyregress1
add plpgsql to Origin
createlang: language "plpgsql" is already installed in database 
"slonyregress1"
loading origin DB with test2/init_schema.sql
done
creating subscriber 2 DB: postgres -h localhost -U postgres -p 5432 
slonyregress2
add plpgsql to subscriber
createlang: language "plpgsql" is already installed in database 
"slonyregress2"
loading subscriber 2 DB from slonyregress1
done
creating subscriber 3 DB: postgres -h localhost -U postgres -p 5432 
slonyregress3
add plpgsql to subscriber
createlang: language "plpgsql" is already installed in database 
"slonyregress3"
loading subscriber 3 DB from slonyregress1
done
creating cluster
done
storing nodes
done
storing paths
done
launching originnode : /opt/postgresql/bin/slon -s500 -g10 slony_regress1 
"dbname=slonyregress1 host=localhost user=postgres port=5432"
launching: /opt/postgresql/bin/slon -s500 -g10 slony_regress1 
"dbname=slonyregress2 host=localhost user=postgres port=5432"
launching: /opt/postgresql/bin/slon -s500 -g10 slony_regress1 
"dbname=slonyregress3 host=localhost user=postgres port=5432"
subscribing
done
generating 838 tranactions of random data
0 %
5 %
10 %
15 %
20 %
25 %
30 %
35 %
40 %
45 %
50 %
55 %
60 %
65 %
70 %
75 %
80 %
85 %
90 %
95 %
100 %
done
launching polling script
loading 839 rows of data
move set from node 1 to node 2
fail over from node 2 to node 3
1 rows behind
2 rows behind
3 rows behind
3 rows behind
4 rows behind
5 rows behind
5 rows behind
... 
300 rows behind
^C





More information about the Slony1-general mailing list