Hi,

First of all, i would like give my most sincere thanks to Mr. Christopher
Brownes for his help in slony-I replication, now I have to create a new set.

Before I did have this one

Cluster_1


/\


                              /      \


                           /            \

                                                                 Cluster_2
           Cluster_3

Now I do have to create a scheme like this one:


Cluster_1


                                                     /\


                              /      \


                           /            \

                                                                 Cluster_2
           Cluster_3


                        /\


                              /       \


                           /             \


             Cluster_4            Cluster_5

For what I have created this configuration files:

config.conf
###########################################################################=
###############################
cluster name=3DCluster_1;

node 1 admin conninfo =3D 'dbname=3DDB_Cluster_1 host=3D127.0.0.1 user=3Dro=
ot
password=3Droot port=3D5435';
node 2 admin conninfo =3D 'dbname=3DDB_Cluster_2 host=3D127.0.0.1 user=3Dro=
ot
password=3Droot port=3D5436';
node 3 admin conninfo =3D 'dbname=3DDB_Cluster_3 host=3D127.0.0.1 user=3Dro=
ot
password=3Droot port=3D5437';
node 4 admin conninfo =3D 'dbname=3DDB_Cluster_4 host=3D127.0.0.1 user=3Dro=
ot
password=3Droot port=3D5438';
node 5 admin conninfo =3D 'dbname=3DDB_Cluster_5 host=3D127.0.0.1 user=3Dro=
ot
password=3Droot port=3D5439';

 init cluster (id=3D1, comment=3D'Nodo maestro del Cluster_2 y Cluster_3');
#init cluster (id=3D3, comment=3D'Nodo maestro del Cluster_4 y Cluster_5');

 create set (id=3D1, origin=3D1, comment=3D'aqui van todas las tablas del
Cluster_1');
#create set (id=3D3, origin=3D3, comment=3D'aqui van todas mis tablas del
Cluster_2');

 set add table (set id=3D1, origin=3D1, id=3D1, fully qualified name=3D'
public.Personas', comment=3D'tabla de Personas del Cluster_1');
#set add table (set id=3D2, origin=3D2, id=3D2, fully qualified name=3D'
public.Personas', comment=3D'tabla de Personas del Cluster_2');
#set add table (set id=3D3, origin=3D3, id=3D3, fully qualified name=3D'
public.Personas', comment=3D'tabla de Personas del Cluster_3');

store node (id=3D2, comment=3D'Nodo esclavo Cluster_2');
store node (id=3D3, comment=3D'Nodo esclavo Cluster_3');
store node (id=3D4, comment=3D'Nodo esclavo Cluster_4');
store node (id=3D5, comment=3D'Nodo esclavo Cluster_5');

store path (server=3D1, client=3D2, conninfo=3D'dbname=3DDB_Cluster_1
host=3D127.0.0.1user=3Droot password=3Droot port=3D5435');
store path (server=3D1, client=3D3, conninfo=3D'dbname=3DDB_Cluster_1
host=3D127.0.0.1user=3Droot password=3Droot port=3D5435');
store path (server=3D1, client=3D4, conninfo=3D'dbname=3DDB_Cluster_1
host=3D127.0.0.1user=3Droot password=3Droot port=3D5435');
store path (server=3D1, client=3D5, conninfo=3D'dbname=3DDB_Cluster_1
host=3D127.0.0.1user=3Droot password=3Droot port=3D5435');
store path (server=3D2, client=3D1, conninfo=3D'dbname=3DDB_Cluster_2
host=3D127.0.0.1user=3Droot password=3Droot port=3D5436');
store path (server=3D2, client=3D3, conninfo=3D'dbname=3DDB_Cluster_2
host=3D127.0.0.1user=3Droot password=3Droot port=3D5436');
store path (server=3D2, client=3D4, conninfo=3D'dbname=3DDB_Cluster_2
host=3D127.0.0.1user=3Droot password=3Droot port=3D5436');
store path (server=3D2, client=3D5, conninfo=3D'dbname=3DDB_Cluster_2
host=3D127.0.0.1user=3Droot password=3Droot port=3D5436');
store path (server=3D3, client=3D1, conninfo=3D'dbname=3DDB_Cluster_3
host=3D127.0.0.1user=3Droot password=3Droot port=3D5437');
store path (server=3D3, client=3D2, conninfo=3D'dbname=3DDB_Cluster_3
host=3D127.0.0.1user=3Droot password=3Droot port=3D5437');
store path (server=3D3, client=3D4, conninfo=3D'dbname=3DDB_Cluster_3
host=3D127.0.0.1user=3Droot password=3Droot port=3D5437');
store path (server=3D3, client=3D5, conninfo=3D'dbname=3DDB_Cluster_3
host=3D127.0.0.1user=3Droot password=3Droot port=3D5437');
store path (server=3D4, client=3D1, conninfo=3D'dbname=3DDB_Cluster_4
host=3D127.0.0.1user=3Droot password=3Droot port=3D5438');
store path (server=3D4, client=3D2, conninfo=3D'dbname=3DDB_Cluster_4
host=3D127.0.0.1user=3Droot password=3Droot port=3D5438');
store path (server=3D4, client=3D3, conninfo=3D'dbname=3DDB_Cluster_4
host=3D127.0.0.1user=3Droot password=3Droot port=3D5438');
store path (server=3D4, client=3D5, conninfo=3D'dbname=3DDB_Cluster_4
host=3D127.0.0.1user=3Droot password=3Droot port=3D5438');
store path (server=3D5, client=3D1, conninfo=3D'dbname=3DDB_Cluster_5
host=3D127.0.0.1user=3Droot password=3Droot port=3D5439');
store path (server=3D5, client=3D2, conninfo=3D'dbname=3DDB_Cluster_5
host=3D127.0.0.1user=3Droot password=3Droot port=3D5439');
store path (server=3D5, client=3D3, conninfo=3D'dbname=3DDB_Cluster_5
host=3D127.0.0.1user=3Droot password=3Droot port=3D5439');
store path (server=3D5, client=3D4, conninfo=3D'dbname=3DDB_Cluster_5
host=3D127.0.0.1user=3Droot password=3Droot port=3D5439');

store listen (origin=3D1, provider=3D1, receiver=3D2);
store listen (origin=3D1, provider=3D1, receiver=3D3);
store listen (origin=3D1, provider=3D1, receiver=3D4);
store listen (origin=3D1, provider=3D1, receiver=3D5);
store listen (origin=3D2, provider=3D2, receiver=3D1);
store listen (origin=3D2, provider=3D2, receiver=3D3);
store listen (origin=3D2, provider=3D2, receiver=3D4);
store listen (origin=3D2, provider=3D2, receiver=3D5);
store listen (origin=3D3, provider=3D3, receiver=3D1);
store listen (origin=3D3, provider=3D3, receiver=3D2);
store listen (origin=3D3, provider=3D3, receiver=3D4);
store listen (origin=3D3, provider=3D3, receiver=3D5);
store listen (origin=3D4, provider=3D4, receiver=3D1);
store listen (origin=3D4, provider=3D4, receiver=3D2);
store listen (origin=3D4, provider=3D4, receiver=3D3);
store listen (origin=3D4, provider=3D4, receiver=3D5);
store listen (origin=3D5, provider=3D5, receiver=3D1);
store listen (origin=3D5, provider=3D5, receiver=3D2);
store listen (origin=3D5, provider=3D5, receiver=3D3);
store listen (origin=3D5, provider=3D5, receiver=3D4);
###########################################################################=
###############################

 Config2.conf
###########################################################################=
###############################
cluster name=3DCluster_1;

node 1 admin conninfo =3D 'dbname=3DDB_Cluster_1 host=3D127.0.0.1 user=3Dro=
ot
password=3Droot port=3D5435';
node 2 admin conninfo =3D 'dbname=3DDB_Cluster_2 host=3D127.0.0.1 user=3Dro=
ot
password=3Droot port=3D5436';
node 3 admin conninfo =3D 'dbname=3DDB_Cluster_3 host=3D127.0.0.1 user=3Dro=
ot
password=3Droot port=3D5437';
node 4 admin conninfo =3D 'dbname=3DDB_Cluster_4 host=3D127.0.0.1 user=3Dro=
ot
password=3Droot port=3D5438';
node 5 admin conninfo =3D 'dbname=3DDB_Cluster_5 host=3D127.0.0.1 user=3Dro=
ot
password=3Droot port=3D5439';

 SUBSCRIBE SET (ID=3D1, PROVIDER=3D1, RECEIVER=3D2, FORWARD=3DYES);
SUBSCRIBE SET (ID=3D1, PROVIDER=3D1, RECEIVER=3D3, FORWARD=3DYES);
SUBSCRIBE SET (ID=3D1, PROVIDER=3D1, RECEIVER=3D4, FORWARD=3DYES);
SUBSCRIBE SET (ID=3D1, PROVIDER=3D1, RECEIVER=3D5, FORWARD=3DYES);
###########################################################################=
###############################

So I tried restricting some of the lines in the "strore path" and "store
listen" in the config.conf, and on the config2.con the subscribe but
apparently did not workout, because when I ran the slonik config.conf it
said:

 Tabla de c=F3digos activa: 1252

C:\Archivos de programa\PostgreSQL\8.2\bin>slonik config.conf
config.conf:50: Error: namespace "_Cluster_1" already exists in database of
node 3

but when i leave as it was at the begginis (all of the nodes replicating to
Cluster_1) it works out very well, and do replicates the data as its ment to
be.

 In other hand I need to implement failover (to node 2 instead of node 1),
so I created a

 failover.conf
###########################################################################=
###############################
failover (id=3D1, backup node=3D2);
###########################################################################=
###############################

 But once again it showed me an error message=85

C:\Archivos de programa\PostgreSQL\8.2\bin>slonik config.conf

 C:\Archivos de programa\PostgreSQL\8.2\bin>slonik config2.conf

C:\Archivos de programa\PostgreSQL\8.2\bin>slonik failover.conf
failover.conf:9: ERROR: syntax error at or near failover

I will really appreciate if anyone can help me out with it=85

Jaison Jos=E9 Gonz=E1lez Chaux
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.slony.info/pipermail/slony1-general/attachments/20080113/=
f0f35f9b/attachment-0001.htm