|
>On Friday November 11 2005 3:02 pm, Melvin Davidson wrote: >> I am trying to set up a simple 3 node rep schema. >> >> Server A -> Slave 1-> Slave2 >> db1( tbl1) db1(tbl1) db1(tbl1) >> >> I have no problem implementing Server A -> Slave 1, but when >> I try with the 3rd node, (Slave 2), I get >> >> [EMAIL PROTECTED] postgres]$ ./slony_reverse.sh >> <stdin>:105: loading of file >> /usr/local/pgsql/share//xxid.v74.sql: PGRES_FATAL_ERROR ERROR: >> current transaction is aborted, commands ignored until end of >> transaction block >> ERROR: current transaction is aborted, commands ignored until >> end of transaction block >What does your server log show as the statement causing the first >error? >Ed ____________________________________________________________ Thanks for all that responded. Apparently I had a slight case of brain fog. The original problem was due to the 3rd server node not being started. DUH! However, I have now come to a second, and hopefully final problem. I am able to have the second node to successfully subscribe to the set, however, attempting to execute slave_node3_subscribe.sh to subscribe the third node fails with: -bash: ./slony_reverse_slv1.sh: Permission denied The following are the scripts involved. define_nodes_and_sets.sh <- This script executes correctly ===================================================================== slonik <<_EOF_ CLUSTER NAME = $SLONYCLUSTER; node 1 admin conninfo = 'dbname=$MASTERDBNAME host=$MASTERHOST port=$PGPORT user=$REPLICATIONUSER'; node 2 admin conninfo = 'dbname=$SLAVEDBNAME host=$SLAVEHOST port=$PGPORT user=$REPLICATIONUSER'; node 3 admin conninfo = 'dbname=$REVERSESLAVEDB host=$MASTERHOST port=5450 user=$REPLICATIONUSER'; init cluster ( id=1, comment = 'Comet Master Node'); CREATE SET (ID=1, ORIGIN=1, COMMENT = 'Comet tables'); SET ADD TABLE (SET ID=1, ORIGIN=1, ID=101, FULLY QUALIFIED NAME = 'slony.table1', comment='table1'); store node (id=2, comment = 'Slony Slave node'); store node (id=3, comment = 'Slony Reverse Slave node'); store path (server = 1, client = 2, conninfo='dbname=$MASTERDBNAME host=$MASTERHOST port=$PGPORT user=$REPLICATIONUSER '); store path (server = 2, client = 1, conninfo='dbname=$SLAVEDBNAME host=$SLAVEHOST port=$PGPORT user=$REPLICATIONUSER '); store path (server = 3, client = 2, conninfo='dbname=$REVERSESLAVEDB host=$MASTERHOST port=5450 user=$REPLICATIONUSER '); store listen (origin=1, provider = 1, receiver =2); store listen (origin=2, provider = 2, receiver =1); store listen (origin=3, provider = 3, receiver =2); store listen (origin=2, provider = 2, receiver =3); slave_node2_subscribe.sh <- This script executes correctly ===================================================================== #!/bin/sh slonik <<_EOF_ cluster name = $SLONYCLUSTER; node 1 admin conninfo = 'dbname=$MASTERDBNAME host=$MASTERHOST port=5480 user=$REPLICATIONUSER'; node 2 admin conninfo = 'dbname=$SLAVEDBNAME host=$SLAVEHOST port=5480 user=$REPLICATIONUSER'; # ---- # Node 2 subscribes sets # ---- subscribe set ( id = 1, provider = 1, receiver = 2, forward = yes); slave_node2_subscribe.sh <- This script fails when executed ===================================================================== #!/bin/sh slonik <<_EOF_ node 1 admin conninfo = 'dbname=$MASTERDB host=$MASTERHOST port=5480 user=$REPLICATIONUSER'; node 2 admin conninfo = 'dbname=$REVERSEMASTERDB host=$REVERSEHOST port=5480 user=$REPLICATIONUSER'; node 3 admin conninfo = 'dbname=$REVERSESLAVEDB host=$REVERSESLAVE port=5450 user=$REPLICATIONUSER'; subscribe set ( id = 1, provider = 2, receiver = 3, forward = no); |
_______________________________________________ Slony1-general mailing list [email protected] http://gborg.postgresql.org/mailman/listinfo/slony1-general
