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);
######################################################################################

best regards...

Jaison J. González Chaux