> Are you sure that those environment variables were set when you ran  
> that
> script? Because the script doesn't set them and for some reason, the
> subscription points to a node 0 as data provider. There are also error
> messages that there is no conninfo for node 0 and that one DB  
> server is
> refusing connections.
>
> It would help to see the content of the sl_node, sl_path, sl_subscribe
> tables of all nodes.
>
> Shell variables turned out not to be a very good idea. We really  
> should re-write the "replicating my first database" and other  
> sections of the docs to move away from them. At the very least they  
> ought to be defined at the head of any script that uses them.
>
What would be the preferred method of executing the FAIL OVER command?

--Richard