Devrim GÜNDÜZ <devrim at gunduz.org> writes:
> What is the trick to setup cascading slaves with Slony-I? I'm probably
> blind, since I did not see anything in the document. What I want is:
>
> pg1 will replicate to pg2 and pg2 will replicate to pg3.
>  
> I setup two different slon_tools.conf for these purposes, initialized
> slony clusters, started daemons for each of them, and subscribed sets.
>
> I could perform initial sync -- however, when I insert a test data from
> pg1, I can see it pg2 -- but not in pg3. 
>
> What am I doing wrong?

You don't need multiple clusters for this, indeed, multiple clusters
will not work, as the trigger handling intended to suppress triggers
on node 2 for the purposes of the first (node 1+2) cluster will
suppress collecting data for the second (node 2+3) cluster.

You set it up as one big cluster, with nodes (say) 1, 2, 3.

- Add all 3 nodes (INIT CLUSTER, STORE NODE)

- Add STORE PATH so the nodes can talk (this could involve 6 paths,
  1->2, 1->3, 2->1, 2->3, 3->1, 3->2)

- Then, for cascaded subscriptions:

   subscribe set (id = 1, provider = 1, receiver = 2, forward=yes);
      (wait for this to complete...)
   subscribe set (id = 1, provider = 2, receiver = 3, forward=no);
-- 
output = ("cbbrowne" "@" "ca.afilias.info")
<http://dba2.int.libertyrms.com/>
Christopher Browne
(416) 673-4124 (land)
"Bother,"  said Pooh,  "Eeyore, ready  two photon  torpedoes  and lock
phasers on the Heffalump, Piglet, meet me in transporter room three"