Thanks for your repaly

I am running the folowing script and getting the 
error "syntax error at or near node"

#!/bin/sh

CLUSTER=cluqsweb
DB1=qsweb
DB2=qswebslave
PREAMBLE="cluster name = $CLUSTER
node 1 admin conninfo = 'dbname=qsweb
host=172.18.5.155 user=postgres password = postgres';
node 2 admin conninfo = 'dbname=qswebslave
host=172.18.5.141 user=postgres password= postgres';
"
origin=1
subscriber=2
mainset=1


slonik <<_EOF_
$PREAMBLE

init cluster (id = 1, comment ='Master Node 1');
create set (id = $mainset, origin = $origin,comment =
'Set $mainset - all qsweb tables');
set add table (set id = $mainset, origin = $origin,
id=1,fully qualified name
='public.admin_owner',comment=' admin_owner');

# waiting for event	 
	 
	WAIT FOR EVENT (
 		 ORIGIN = ALL,

   CONFIRMED = ALL,
   WAIT ON = 1
);


store node (id = 2, comment ='Slave Node 1');
store path (server = 1, client = 2,
  conninfo ='dbname=qsweb host=172.18.5.155
user=postgres password = postgres');
store path (server = 2, client = 1,
 conninfo ='dbname=qswebslave host=172.18.5.141
user=postgres password = postgres');
store listen (origin = $origin, provider = 1, receiver
= 2);
store listen (origin = $origin, provider = 2, receiver
= 1);


_EOF_




Can you please tell me where I am doing wrong



--- Mikko Partio <dun at paprikalaatikko.be> wrote:

> Ashish Karalkar wrote:
> 
> > I need to insert new table in an existing
> replication
> > set for that i want to create new set.
> > can anybody please tell me do i need to create
> this
> > new set in the same replication cluster in which
> it
> > will be merged later on and If yes how to do it??
> > I used giving same cluster name in the slonik
> script
> > for creating new set but it gives error that
> cluster
> > already exist.
> 
> Yes you should create it to the same cluster. It
> seems that you have 
> tried to create the cluster again, which isn't the
> proper course of action.
> 
> You should first specify the preamble and then use
> the create 
> set-command. For more info you really should see the
> Slony guide: 
> <http://linuxdatabases.info/info/slony.html>
> 
> 
> MP
> 



 
____________________________________________________________________________________
Want to start your own business?
Learn how on Yahoo! Small Business.
http://smallbusiness.yahoo.com/r-index