CS DBA cs_dba at consistentstate.com
Thu Sep 15 19:18:00 PDT 2011
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
---------------------------------------------



More information about the Slony1-general mailing list