Hi all.
This is some information on windows.
It displays a very good result.:-)
PostgreSQL 8.1.4
Slony-I 1.2 rc4
Thanks.!!
Regards,
Hiroshi Saito
$ run_test.sh test1
test: test1
----------------------------------------------------
$Id: README,v 1.5 2006/08/04 20:06:24 cbbrowne Exp $
test1 is a basic test that replication generally functions.
It doesn't try to do anything too terribly fancy: It creates three
simple tables as one replication set, and replicates them from one
database to another.
The three tables are of the three interesting types:
1. table1 has a formal primary key
2. table2 lacks a formal primary key, but has a candidate primary key
3. table3 has no candidate primary key; Slony-I is expected to
generate one on its own.
It actually tries replicating a fourth table, which has an invalid
candidate primary key (columns not defined NOT NULL), which should
cause it to be rejected. That is done in a slonik TRY {} block.
It also creates...
5. table5 which has columns of all sorts of vaguely esoteric types to
exercise that points, paths, bitmaps, mac addresses, and inet types
replicate properly.
----------------------------------------------------
creating origin DB: postgres -h localhost -U postgres -p 5432 slonyregress1
add plpgsql to Origin
loading origin DB with test1/init_schema.sql
done
creating subscriber 2 DB: postgres -h localhost -U postgres -p 5432
slonyregress2
add plpgsql to subscriber
loading subscriber 2 DB from slonyregress1
done
creating cluster
done
storing nodes
done
storing paths
done
launching originnode : /usr/local/pgsql/bin/slon -s500 -g10 -d2 slony_regress1
"dbname=slonyregress1 host=localhost user=postgres port=5432"
launching: /usr/local/pgsql/bin/slon -s500 -g10 -d2 slony_regress1
"dbname=slonyregress2 host=localhost user=postgres port=5432"
subscribing
done
generating 821 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 data
done
1 rows behind
1 rows behind
slony is caught up
getting data from origin DB for diffing
done
getting data from node 2 for diffing against origin
comparing
subscriber node 2 is the same as origin node 1
done
**** killing slon node 1
[1]- Terminated $opgbindir/slon -s500 -g10 -d2 $cluster "$conninfo"
>$mktmp/slon_log.${originnode} 2>$mktmp/slon_log.${originnode}
**** killing slon node 2
[2]+ Terminated $pgbindir/slon -s500 -g10 -d2 $cluster "$conninfo"
>>$mktmp/slon_log.${alias} 2>&1
waiting for slons to die
done
dropping database
slonyregress1
slonyregress2
done
***************************
test test1 completed successfully
***************************
_______________________________________________
Slony1-general mailing list
[email protected]
http://gborg.postgresql.org/mailman/listinfo/slony1-general
