I have three nodes. Node 1 is the master and nodes 2 and 3 are subscribers.
I am trying to failover from node 1 to node 3. Although the failover command
succeeds and prints "NOTICE: 00000: failedNode: set 1 has other direct
receivers - change providers only" several times, node 3 is still read-only
and on node 3 sl_set.sl_origin = node 1. Could someone please give pointers
on how to troubleshoot this? I'd like to find out how to make node 3
writable again and make the set originate on node 3.
Thank you.
-Fiel
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://gborg.postgresql.org/pipermail/slony1-general/attachments/20051003/49055c73/attachment.html