Slony1 PostgreSQL Replication

Author

test2?

Michael Crozier

2006-01-13, 8:24 pm

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

cbbrowne-swQf4SbcV9C7WVzo/KQ3Mw@public.gmane.org

2006-01-15, 3:23 am

>
> 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?

test2 was never quite completed...

Darcy may be able to speak more to what it was intended to do; I found it
somewhat confusing in intent... That being the case, expecting it to work
just right may be a bit of a reach :-).

Sponsored Links