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