Thu Sep 15 19:18:00 PDT 2011
- Previous message: [Slony1-general] Errors adding a 3rd slave with SLONY 2.0.7
- Next message: [Slony1-general] Cannot do a switchover (solved)
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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 ---------------------------------------------
- Previous message: [Slony1-general] Errors adding a 3rd slave with SLONY 2.0.7
- Next message: [Slony1-general] Cannot do a switchover (solved)
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list