hi all,

Iam new to slony with postgres. Using Slony 2.x with postgres 8.4

I used this link: http://www.slony.info/documentation/failover.html

In my setup, there is only one master (node:1) and one slave (node:2)

to do some switchover testing.. The controlled switchover works fine.

The test i wanted to do was 'what if master server goes down - like a
restart'. I want the 'slave' to become master and accept write requests. and
when the original master server comes back up, i want it to become the
'slave'.

I tried this
        1) on Master, did shutdown -r
        2) login to slave and run
            lock set (id = 1, origin = 1);
            move set (id = 1, old origin = 1, new origin = 2);

The above does not work, as it is trying to talk with original master.

Should i run the 'failover' command?  failover (id = 1, backup node = 2); there
are some big warnings against doing this in the slony link above

If so, how do i make the old master when it restarts, run as slave.

Thanks in advance.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.slony.info/pipermail/slony1-general/attachments/20110215/d11fa4b2/attachment.htm