On Wed, 27 Feb 2008 12:53:35 +0100, "Stéphane A. Schildknecht"
<stephane.schildknecht at postgresqlfr.org> 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