On 9/14/2004 7:35 AM, Justin Clift wrote:
> Hi all,
> 
> Using Slony 1.0.2 on Red Hat Enterprise Linux 3 AS with PG 7.4.5.
> 
> Trying to get a simple switch over of a 2 node set (1 master, 1 slave), 
> but I'm getting this error:
> 
> <stdin>:1: ERROR: syntax error at or near lock
> 
> When running a script for slonik with the appropriate commands.  The 
> commands are straight out of the slony-I-failover.txt doc, so I'm not 
> sure what's going on.
> 
> Here's the script:
> 
> ***********
> 
> #!/bin/sh
> 
> CLUSTERNAME=somecluster
> MASTERDBNAME=mydb
> SLAVEDBNAME=mydb
> MASTERHOST=host1
> SLAVEHOST=host2
> REPLICATIONUSER=postgres
> 
> # Perform the switch over
> slonik << _EOF_
> 
>          # Namespace to use
>          cluster name = $CLUSTERNAME;

try admin conninfo here

> 
>          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_
> 
> ***********
> 
> Any ideas?
> 
> Regards and best wishes,
> 
> Justin Clift
> 
> _______________________________________________
> Slony1-general mailing list
> Slony1-general at gborg.postgresql.org
> http://gborg.postgresql.org/mailman/listinfo/slony1-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 #