that worked. thanks jan

cheers,
kailash

On Mon, 15 Nov 2004 13:38:51 -0500, Jan Wieck <janwieck at yahoo.com> wrote:
> You are on the wrong mailing list. The Slony team uses the mailing list
> slony1-general at gborg.postgresql.org
> 
> 
> 
> 
> On 11/15/2004 1:10 PM, Kailash Vyas wrote:
> > hi,
> >
> > i have installed the postgres replication on 2 remote servers. it is
> > able to replicate the data now i want to test the swithover and
> > failover. do i have to stop the postgres server for that.
> >
> > the 2 slon processes are running on the remote servers.
> >
> > i made the following slonik script for the failover
> >
> > #!/bin/sh
> > slonik <<_EOF_
> >     # ----
> >     # This defines which namespace the replication system uses
> >     # ----
> >     cluster name = $CLUSTERNAME;
> >
> >         lock set (id = 1, origin = 1);
> >         wait for event (origin = 1, confirmed = 2);
> >         move set (id = 1, old origin = 1, new origin = 2);
> >         wait for event (origin = 1, confirmed = 2);
> >
> > _EOF_
> 
> That script lacks the admin conninfo statements and is for "switchover".
> 
> Jan
> 
> >
> > it gives me the following error when i run this shell script
> >
> > <stdin>:12: ERROR: syntax error at or near lock
> >
> > do i need to specify anything else in this case.
> >
> > thanks,
> > kailash
> > _______________________________________________
> > Pgreplication-general mailing list
> > Pgreplication-general at gborg.postgresql.org
> > http://gborg.postgresql.org/mailman/listinfo/pgreplication-general
> 
> --
> #======================================================================#
> # It's easier to get forgiveness for being wrong than for being right. #
> # Let's break this rule - forgive me.                                  #
> #================================================== JanWieck at Yahoo.com #
>