francescoboccacci at libero.it francescoboccacci at libero.it
Thu Sep 29 01:28:01 PDT 2011
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





More information about the Slony1-general mailing list