Hi,
I have two Postgres db's running Slony-I and I need to perform a
switchover. I read the documentation on the homepage but still have
some questions on the matter. My question is do I have to wait for the
events to be done both when locking AND moving sets or only the
latter, i.e. should the script be written as:
[CODE:]
lock set (id = 1, origin = 1);
move set (id = 1, old origin = 1, new origin = 2);
wait for event (origin = 1, confirmed = 2);
lock set (id = 2, origin = 1);
move set (id = 2, old origin = 1, new origin = 2);
wait for event (origin = 1, confirmed = 2);
lock set (id = 3, origin = 1);
move set (id = 3, old origin = 1, new origin = 2);
wait for event (origin = 1, confirmed = 2);
[END CODE:]
or should it look like
[CODE:]
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);
lock set (id = 2, origin = 1);
wait for event (origin = 1, confirmed = 2);
move set (id = 2, old origin = 1, new origin = 2);
wait for event (origin = 1, confirmed = 2);
lock set (id = 3, origin = 1);
wait for event (origin = 1, confirmed = 2);
move set (id = 3, old origin = 1, new origin = 2);
wait for event (origin = 1, confirmed = 2);
[END CODE:]
Kind regards /Ulas Albayrak
_______________________________________________
Slony1-general mailing list
[email protected]
http://lists.slony.info/mailman/listinfo/slony1-general
