Thu Oct 26 16:53:37 PDT 2006
- Previous message: [Slony1-general] New slonik SYNC command
- Next message: [Slony1-general] switchover and switchback!
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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 -------------- next part -------------- An HTML attachment was scrubbed... URL: http://gborg.postgresql.org/pipermail/slony1-general/attachments/20061026/6b48da2a/attachment-0001.html
- Previous message: [Slony1-general] New slonik SYNC command
- Next message: [Slony1-general] switchover and switchback!
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list