"Stéphane A. Schildknecht" stephane.schildknecht at postgresqlfr.org
Wed Feb 27 03:16:11 PST 2008
Sebastien Lardiere a écrit :
> On Wed, 27 Feb 2008 11:06:01 +0100, "Stéphane A. Schildknecht"
> <stephane.schildknecht at postgresqlfr.org> wrote:
>> Sebastien Lardiere a écrit :
>>> Hello
>>>
>>> I'm testing a setup with Pg 8.3.0 and Slony 1.2.13 on RHEL4.
>>>
>> (...)
>>
>> Hello,
>>
>> Could you give us the scheme of your replication network ?
>>
>> Which node is master, is replication in L or in Y ?
>>
> 
> 1 is master, 2 and 3 are slave, so in Y. I test "move set", with 2 in master and 3 and 1 in slave, also in Y, and it's the same.
> 
> But I "drop node" the third, and failover work, with only 2 node ! 

Regarding documentation and my experience, you should be able to failover in Y
also.

If you have
  1
 / \
2   3

and execute failover( id=1, backup node=2), you should get
 2
 |
 3

What do you have in sl_subscribe table before and after failover ?

SAS


More information about the Slony1-general mailing list