Sun Jan 13 07:35:58 PST 2008
- Previous message: [Slony1-general] Query about Slony-i from Colombia
- Next message: [Slony1-general] Re: Query about Slony-i from Colombia
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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
- Previous message: [Slony1-general] Query about Slony-i from Colombia
- Next message: [Slony1-general] Re: Query about Slony-i from Colombia
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list