Hi Everyone,

Does any of you know if there is any tools that can be use, has scripts
templates available on easy the job of setting up clusters, and subscribing
the sets?
I am trying to find template scripts to setup clusters for multi-slave
environment. I am not doing something special nor unique. My environment is
very simple and straight forward. I just need a scripts to run to setup my 3
slaves clusters, that's all.  I need something like the one in attachment
(please see attachment). in case if you don't see any attachments, since I
am not too sure how to attach it using my Gmail to send this mailing list, I
have post the script at below



Listing 1. cluster_setup.sh


#!/bin/sh

CLUSTER=3Dsql_cluster
DB1=3Dcontactdb
DB2=3Dcontactdb_slave
H1=3Dlocalhost
H2=3Dlocalhost
U=3Dpostgres

slonik <<_EOF_

cluster name =3D $CLUSTER;

node 1 admin conninfo =3D 'dbname=3D$DB1 host=3D$H1 user=3D$U';
node 2 admin conninfo =3D 'dbname=3D$DB2 host=3D$H2 user=3D$U';

init cluster (id =3D 1, comment =3D 'Node 1');

create set (id =3D 1, origin =3D 1,
       comment =3D 'contact table');

set add table (set id =3D 1, origin =3D 1, id =3D 1,
        full qualified name =3D 'public.contact',
        comment =3D 'Table contact');

set add sequence (set id =3D 1, origin =3D 1, id =3D 2,
        full qualified name =3D 'public.contact_seq',
        comment =3D 'Sequence contact_seq');

store node (id =3D 2, comment =3D 'Node 2');
store path (server =3D 1, client =3D 2,
      conninfo =3D 'dbname=3D$DB1 host=3D$H1 user=3D$U');

store path (server =3D 2, client =3D 1,
           conninfo =3D 'dbname=3D$DB2 host=3D$H2 user=3D$U');

store listen (origin =3D 1, provider =3D 1, receiver =3D 2);
store listen (origin =3D 2, provider =3D 2, receiver =3D 1);


--
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.slony.info/pipermail/slony1-general/attachments/20090727/=
4839520d/attachment.htm