Thu Aug 27 13:23:44 PDT 2009
- Previous message: [Slony1-general] is there any way to keep transaction replication atomic
- Next message: [Slony1-general] Re: Switchovers with Slony1-2.0.2
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Hi I've recently been testing Slony-1 2.0.2 with PostgreSQL 8.3.7. Replication works great, but I can't seem to get it to perform a switchover. Our typical switchover command set from Slony1-1.2 does not work: node 1 admin conninfo=* node 2 admin conninfo=* node 3 admin conninfo=* 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); Executing the above produces: <stdin>:3: Error: No admin conninfo provided for node -1 <stdin>:5: Error: No admin conninfo provided for node -1 Now, looking this up has led me to find that we now need to specify a 'wait on=' option for the WAIT FOR EVENT commands. However, after adding these (wait on = 1), I get another error after issuing the script: $ slonik switch.slonik switch.slonik:6: Error: script did not generate any event on node 1 The set is however locked on all nodes, so I'm unsure as to how this did not generate any events on Node 1. Any ideas? Thanks, Steve Polyack
- Previous message: [Slony1-general] is there any way to keep transaction replication atomic
- Next message: [Slony1-general] Re: Switchovers with Slony1-2.0.2
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list