It was issues with the wait for event call, I was using the v 1 format..



/Kevin


-- 
===========================
Kevin Kempter
Consistent State
www.consistentstate.com
303-217-0961
===========================

Sent from my iPad

On Sep 15, 2011, at 20:18, CS DBA <cs_dba at consistentstate.com> wrote:

> Hi All;
> 
> I have a 3 node cluster which is up and replicating.  I'm using slony v 2.0.7 and postgres 9.1.0 on nodes 1 and 2 plus postgres 9.0.4 on node3.
> 
> I have a simple switchover script, see below for the script listing.
> when I run it I get this:
> 
> 
> $ ./sl_switchover2
> <stdin>:8: Error: No admin conninfo provided for node -1
> <stdin>:10: Error: No admin conninfo provided for node -1
> 
> 
> 
> 
> 
> ----------------------------------------------
> 
> #!/bin/bash
> 
> 
> slonik <<_EOF_
> # ----
> cluster name = slony_pgbench ;
> 
> node 1 admin conninfo = 'dbname=rep_bench_node1 host=172.16.32.155 port=5432 user=slony ';
> node 2 admin conninfo = 'dbname=rep_bench_node2 host=172.16.32.156 port=5432 user=slony ';
> node 3 admin conninfo = 'dbname=rep_bench_node3 host=172.16.32.157 port=5432 user=slony';
> 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_
> 
> 
> 
> 
> 
> 
> 
> -- 
> ---------------------------------------------
> Kevin Kempter       -       Constent State
> A PostgreSQL Professional Services Company
>          www.consistentstate.com
> ---------------------------------------------
>