Bill Moran <wmoran at collaborativefusion.com> writes:

> In response to Jerry Sievers <jerry at jerrysievers.com>:
> 
> > Slony 1.1.5
> > 
> > Assuming a cascaded cluster of 3 nodes arranged as follows;
> > 
> > Master
> >         Slave1
> >                 Slave2
> > 
> > If the middle tier Slave1 is totally lost, is there a way to get
> > Slave2 pointing to Master without data loss, or at all?
> > 
> > I am unable to do it with Slonik but had thought this was workable. 
> 
> What, exactly, did you try to do?
> 
> You should be able to do it by simply issuing a new subscribe set ()
> command with the correct parameters to subscribe it to Master.

That was my assumption and I guess also believe that Slonik would feed
the new subscription info directly to the now cut=-off slave. .  This
does not seem to be the case.

original subscription looked like 

set 1,
provider 2,
receiver 3

New subscription;

set 1,
provider 1, 
receiver 3

But with the node that was in the middle feeding slave 2 down, I think
there's no way slave 2 ever hears of the new subscription and it keeps
trying to connect to the slave that used to be feeding it.

I've queried the sl_* tables on the  node that I want to reposition
and see that nothing is  changing.  

Any ideas? 

> http://slony.info/documentation/reshape.html
> 
> -- 
> Bill Moran
> Collaborative Fusion Inc.
> http://people.collaborativefusion.com/~wmoran/
> 
> wmoran at collaborativefusion.com
> Phone: 412-422-3463x4023
> 

-- 
-------------------------------------------------------------------------------
Jerry Sievers   732 365-2844 (work)     Production Database Administrator
                305 321-1144 (mobil	WWW E-Commerce Consultant