|
Hi, I just completed a simple 2 node switchover. Now I’d
like to switch ‘back’ to my original configuration and I would like
to confirm if what I’m doing is correct. My original file was the cookie cutter… slonik << _EOF_ cluster
name = mycluster; node
1 admin conninfo = ‘dbname=mydb_1 host=##.##.##.## port=5432
user=postgres’; node
2 admin conninfo = ‘dbname=mydb_2 host=##.##.##.## port=5432
user=postgres’; 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_ Now to get things back to where they were before I did the
switchover, I assume that I should execute… slonik << _EOF_ cluster
name = mycluster; node
1 admin conninfo = ‘dbname=mydb_1 host=##.##.##.## port=5432
user=postgres’; node
2 admin conninfo = ‘dbname=mydb_2 host=##.##.##.## port=5432
user=postgres’; lock
set (id = 2, origin = 2); wait
for event (origin = 2, confirmed = 1); move
set (id = 2, old origin = 2, new origin = 1); wait
for event (origin = 2, confirmed = 1); _EOF_ So I just swapped every 1 for a 2 and every 2 for a 1 in the
last four lines! Is this correct? Thanks Mick |
_______________________________________________ Slony1-general mailing list [email protected] http://gborg.postgresql.org/mailman/listinfo/slony1-general
