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 <[EMAIL PROTECTED]> 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
_______________________________________________
Slony1-general mailing list
[email protected]
http://gborg.postgresql.org/mailman/listinfo/slony1-general
