Wed Aug 18 11:23:26 PDT 2004
- Previous message: [Slony1-general] general replication question
- Next message: [Slony1-general] Large Objects Question
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Hi! Is there any documentation for slonik? I've only found code samples on the web. I am trying to do a 3 node arrangement, and I think I am getting the provider and receiver values wrong: slonik <<_EOF_ cluster name = chado_gec_replicate; node 1 admin conninfo = 'dbname=chado_gec host=soleus user=postgres'; node 2 admin conninfo = 'dbname=chado_gec host=soleusq1 user=postgres'; node 3 admin conninfo = 'dbname=chado_gec host=soleusq2 user=postgres'; init cluster ( id = 1, comment = 'Node 1' ); create set ( id = 1, origin = 1, comment = 'All chado_gec tables' ); set add table ( set id = 1, origin = 1, id = 1, full qualified name = 'public.acquisition', comment = 'Table acquisition' ); set add table ( set id = 1, origin = 1, id = 2, full qualified name = 'public.acquisition_relationship', comment = 'Table acquisition_relationship' ); . . . set add table ( set id = 1, origin = 1, id = 88, full qualified name = 'public.tableinfo', comment = 'Table tableinfo' ); set add table ( set id = 1, origin = 1, id = 89, full qualified name = 'public.treatment', comment = 'Table treatment' ); store node ( id = 2, comment = 'Node 2' ); store node ( id = 3, comment = 'Node 3' ); store path ( server = 1, client = 2, conninfo = 'dbname=chado_gec host=soleus user=postgres'); store path ( server = 2, client = 3, conninfo = 'dbname=chado_gec host=soleusq1 user=postgres'); store path ( server = 3, client = 1, conninfo = 'dbname=chado_gec host=soleusq2 user=postgres'); store listen ( origin = 1, provider = 1, receiver = 2 ); store listen ( origin = 2, provider = 2, receiver = 3 ); store listen ( origin = 3, provider = 3, receiver = 1 ); _EOF_ and slonik <<_EOF_ cluster name = chado_gec_replicate; node 1 admin conninfo = 'dbname=chado_gec host=soleus user=postgres'; node 2 admin conninfo = 'dbname=chado_gec host=soleusq1 user=postgres'; node 3 admin conninfo = 'dbname=chado_gec host=soleusq2 user=postgres'; subscribe set ( id = 1, provider = 1, receiver = 3, forward = no ); _EOF_ Thanks for the help!
- Previous message: [Slony1-general] general replication question
- Next message: [Slony1-general] Large Objects Question
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list