On Thu, May 5, 2011 at 7:33 AM, Nithya Rajendran <r-nit...@hcl.com> 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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to