I have the slony 1.24 running on postgres 8.34

I get the following error when i run my slon setup script. I have 3 nodes, 1
replicated to 2 and 2 cascades to 3.

Error
<stdin>:23: PGRES_FATAL_ERROR select "_slonytest".subscribeSet(1, 2, 4,
'f');  - ERROR:  Slony-I: subscribeSet(): set 1 not found

My script

slonik <<_EOF_
cluster name = slonytest;
node 1 admin conninfo = 'dbname=slonytestdb host=db1.eng.company.net
user=pos  password=pos123';
node 2 admin conninfo = 'dbname=slonytestdb host=db2.eng.company.net
user=pos  password=pos123';
node 4 admin conninfo = 'dbname=slonytestdb host=db3.eng.company.net
user=pos  password=pos123';

init cluster ( id=1, comment = 'Master Node');
store node (id=2, comment = 'Primary Slave node');
store node (id=4, comment = 'Primary query node');


store path (server = 1, client = 2, conninfo='dbname=slontestdb
host=db1.eng.company.net user=postgres password=pos123');
store path (server = 2, client = 1, conninfo='dbname=slontestdb
host=db2.eng.company.net  user=pos password=pos123');
store path (server = 2, client = 4, conninfo='dbname=slontestdb
host=db3.eng.company.net  user=pos password=postgres1234');
store path (server = 4, client = 2, conninfo='dbname=slontestdb
host=db4.eng.company.net  user=pos password=pos123');


create set (id=1, origin=1, comment='repl Tables');
set add table (set id=1, origin=1, id=1, fully qualified name =
'moot.users', comment='users table');


subscribe set ( id = 1, provider = 1, receiver = 2, forward = yes);
subscribe set ( id = 1, provider = 2, receiver = 4, forward = no);
_EOF_

Any insight would be appreciated.
If I comment out the last line (subscribing set 1 from 2 to 4 ), it runs
without error, so it recognizes set 1 if I don't have the cascaded
subscribe.

-- 
View this message in context: 
http://old.nabble.com/Error-while-trying-to-set-upi-cascaded-slave-tp27380132p27380132.html
Sent from the Slony-I -- General mailing list archive at Nabble.com.

_______________________________________________
Slony1-general mailing list
[email protected]
http://lists.slony.info/mailman/listinfo/slony1-general

Reply via email to