Jan Wieck JanWieck at Yahoo.com
Thu Aug 9 10:26:19 PDT 2007
On 7/31/2007 6:54 PM, Jerry Sievers wrote:
> 
> Chris, this is very helpful.  Thanks!> 
> 
> Basically, I misunderstood the documentation and believe that what I
> was trying was supported and straightforward to do.  You have affirmed
> that it is not. 

What you intended to do is well supported and was so from day one. What 
the "subscribe set" command, that is supposed to let slave2 become a 
direct subscriber, requires is a path to the master. If that didn't 
exist, the subscribe should have failed. So all you have to do is

     store path (master->slave2)
     store path (slave2->master)
     subscribe set (...)

After that subscribe set finished and slave2 is catching up again, you 
can drop slave1 and are done.

I am not sure if 1.1.5 maintained the sl_listen table automagically. So 
you might want to add the appropriate "store listen" commands in there 
as well.


Jan

-- 
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck at Yahoo.com #


More information about the Slony1-general mailing list