Jared Fox jaredfox
Wed Aug 18 11:23:26 PDT 2004
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!



More information about the Slony1-general mailing list