Hi,
i have some problems with slony 2.1.0. I have 2 server (192.168.22.225 Master,
192.168.22.226 Slave) .
I run the following cluster.sh into main server:
CLUSTER=sql_cluster_test
DB1=test_grade
H1=192.168.22.225
H2=192.168.22.226
DB2=test_grade
U=xxxx
P=xxxx
/usr/lib/postgresql/8.4/bin/slonik <<_EOF_
cluster name = $CLUSTER;
node 1 admin conninfo = 'dbname=$DB1 host=$H1 user=$U password=$P';
node 2 admin conninfo = 'dbname=$DB2 host=$H2 user=$U password=$P';
init cluster (id = 1, comment = 'Master Node');
create set (id = 1, origin = 1, comment = 'contact table');
########TABLES###############################
set add table (set id = 1, origin = 1, id = 1,
full qualified name = 'public.testtable',
comment = 'Table testtable');
....
...
then i run:
/usr/lib/postgresql/8.4/bin/slon sql_cluster_test "dbname=test_grade
user=xxxx" > slon1.log &
in a master server and
usr/lib/postgresql/8.4/bin/slon sql_cluster_test "dbname=test_grade
user=xxxx" > slon1.log &
in slave server without errors. At the end i run the following
subscribe_test.sh script:
CLUSTER=sql_cluster_test
DB1=test_grade
H1=192.168.22.225
H2=192.168.22.226
DB2=test_grade
U=xxxx
P=xxxx
/usr/lib/postgresql/8.4/bin/slonik <<_EOF_
cluster name = $CLUSTER;
node 1 admin conninfo = 'dbname=$DB1 host=$H1 user=$U';
node 2 admin conninfo = 'dbname=$DB2 host=$H2 user=$U';
subscribe set (id = 1, provider = 1, receiver = 2, forward = no);
_EOF_
This is the returned message :
waiting for events (2,5000000001) only at (2,0) to be confirmed on node 1
waiting for events (2,5000000001) only at (2,0) to be confirmed on node 1
...
..
and the replication in slave tables aren't available and the replication
systema doesn't work.
Please let me know if i'm doing some mistakes.
Thanks
Franesco
_______________________________________________
Slony1-general mailing list
[email protected]
http://lists.slony.info/mailman/listinfo/slony1-general
