>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
 >>
 >> [postgres at slv 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);
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://gborg.postgresql.org/pipermail/slony1-general/attachments/20051114/1fb7e317/attachment.html