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 <[email protected]> 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 > --------------------------------------------- > _______________________________________________ Slony1-general mailing list [email protected] http://lists.slony.info/mailman/listinfo/slony1-general
