On Wed, 27 Feb 2008 12:53:35 +0100, "Stéphane A. Schildknecht"
<[EMAIL PROTECTED]> wrote:
>>
>> Before failover, i've got :
>>
>>
>> bar=# select * from _qsr_repl.sl_subscribe ;
>> sub_set | sub_provider | sub_receiver | sub_forward | sub_active
>> ---------+--------------+--------------+-------------+------------
>> 1 | 1 | 2 | f | t
>> 1 | 1 | 3 | f | t
>> (2 rows)
>>
>> And after too, because failover fail, and so nothing is done.
>
>
> 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.
On 2, it's ok :
infoctr=# select * from _qsr_repl.sl_subscribe ;
sub_set | sub_provider | sub_receiver | sub_forward | sub_active
---------+--------------+--------------+-------------+------------
1 | 2 | 3 | t | t
(1 row)
But on 3 , I've got a problem :
infoctr=# SELECT * from _qsr_repl.sl_subscribe ;
sub_set | sub_provider | sub_receiver | sub_forward | sub_active
---------+--------------+--------------+-------------+------------
1 | 3 | 2 | t | t
1 | 2 | 3 | t | t
And replication doesn't work anymore
--
Sébastien
_______________________________________________
Slony1-general mailing list
[email protected]
http://lists.slony.info/mailman/listinfo/slony1-general
