Thu Sep 29 01:28:01 PDT 2011
- Previous message: [Slony1-general] Normal broken output or bad package?
- Next message: [Slony1-general] Slony Problem
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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
- Previous message: [Slony1-general] Normal broken output or bad package?
- Next message: [Slony1-general] Slony Problem
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list