CLUSTER=sql_cluster_allgrades
DB1=grade1
DB2=grade2
DB3=grade3
DB4=grade4
DB9=grade9
U=navmap
P=navmap
/usr/lib/postgresql/8.4/bin/slonik <<_EOF_

cluster name = $CLUSTER;

node 1 admin conninfo = 'dbname=$DB1  user=$U';
node 2 admin conninfo = 'dbname=$DB2  user=$U';
node 3 admin conninfo = 'dbname=$DB3  user=$U';
node 4 admin conninfo = 'dbname=$DB4  user=$U';
node 9 admin conninfo = 'dbname=$DB9  user=$U';


subscribe set (id = 1, provider = 1, receiver = 2, forward = yes);
subscribe set (id = 1, provider = 1, receiver = 3, forward = yes);
subscribe set (id = 1, provider = 1, receiver = 4, forward = yes);
subscribe set (id = 1, provider = 1, receiver = 9, forward = yes);


_EOF_