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