"Jaison J. González Chaux" <g0chman at gmail.com> writes:
> Hi everyone,
>
> I am running slony-i with the failover script, it actually replicates
> all the nodes that it is suppoused to, but when i am executing the
> failover.conf script it shows me this error message, tried executing
> it with a switchover but nothing

>
> I will really appreciate if someone can give a hint, or at least give
> me some suggestions

>
> C:\Archivos de programa\PostgreSQL\8.2\bin>slonik failover.conf
> failover.conf:14: PGRES_FATAL_ERROR select "_Clus1".failedNode(1, 3);
> - ERROR: Slony-I: cannot failover - node 2 has no path to the backup node
>
> Failover.conf
> ######################################################################################
> cluster name=Clus1;
>
> node 1 admin conninfo = 'dbname=DB_Cluster_1 host=127.0.0.1 user=root
> password=root port=5435';
> node 2 admin conninfo = 'dbname=DB_Cluster_2 host=127.0.0.1 user=root
> password=root port=5436';
> node 3 admin conninfo = 'dbname=DB_Cluster_3 host=127.0.0.1 user=root
> password=root port=5437';
>
> failover (id=1, backup node=3);
> ######################################################################################

It would seem to me that the error message is already giving some
clues...

I'm guessing that you have some really minimal set of paths defined in
sl_path (via the Slonik command "STORE PATH").

Evidently, node #2 has no path defined in sl_path that allows it
access to node #3.

That being the case, after the failover, there will be no way for node
#2 to access events or data generated by node #3.

In effect, you can't fail over if you haven't got a configuration that
will function after the failover.

Probably the appropriate STORE PATH that was needed was the following:

  store path (server=3, client=2, conninfo='dbname=DB_Cluster_3 host=127.0.0.1 user=root password=root port=5437';
-- 
let name="cbbrowne" and tld="acm.org" in String.concat "@" [name;tld];;
http://linuxfinances.info/info/sap.html
Paranoid schizophrenics outnumber their enemies at least two to one.