On Thu, May 5, 2011 at 7:33 AM, Nithya Rajendran <r-nithya@xxxxxxx> wrote: [Disclaimer: I have minimal experience with hot standby, the below is just from reading the docs] > ===> How to find whether current postgres is running as master or slave? SELECT pg_is_in_recovery(); will tell you (should be false for the master, true for the slave). > ====> What is the procedure to make the failed master as working slave? You mean, after you've failed over from A to B, how to bring A back up as a slave of B? You should be able to just follow the steps of setting up a master-slave pair, with B as the new master, and A the new slave. Josh -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
