Sebastien Lardiere a écrit :
> 
> 
> On Wed, 27 Feb 2008 16:55:19 +0100, "Stéphane A. Schildknecht"
> <stephane.schildknecht at postgresqlfr.org> wrote:
>> Sebastien Lardiere a écrit :
>>> On Wed, 27 Feb 2008 13:55:42 +0100, Sebastien Lardiere
>> <sebastien at lardiere.net> wrote:
>>>>>> Shouldn't node 2 and/or 3 be forwarder if you want to use one of them
>>>> as
>>>>> a
>>>>>> master ?
>>>>> You're right, i enable forward for 2 and 3, and then failover work.
>>>>>
>>> Ok, it work, and i understand why i've got some error :
>>>
>>> - I have to set all direct receiver with forward = yes
>>>
>>> - When I do failover, i have to wait before send "drop node" for remover
>> the old master.
>>
>> Did you have to explicitly drop the node ? Documentation says it is done
>> on
>> every subscriber by the failover command. (so does slonik source code).
>>
> No, in fact, the old master was not dropped after the failover. I wait and
> verify that the new scheme work, then send "drop node" .

"Ici, ça marche" :-)

I tried with three nodes, 1, 2 and 3, 1 being master for 2 and 3.

A failover on node 1 leaves me with node 2 and 3, 2 being master for 3. Both 2
and 3 now ignore 1.

PG 8.2.6 and slony 1.2.13.

Regards,
SAS