Re: [GENERAL] Queries Regarding Postgresql Replication

2011-08-02 Thread senthilnathan
*> What is the procedure to make the failed master as working slave?* Check whether the following steps works for you... Assume the following is your use case., Master > Slave(Stand by..) Master replicating to slave. At time when master failed, the slave takes over as new master. Now

Re: [GENERAL] Queries Regarding Postgresql Replication

2011-08-02 Thread senthilnathan
*> What is the procedure to make the failed master as working slave?* Check whether the following steps works for you... Assume the following is your use case., Master > Slave(Stand by..) Master replicating to slave. At time when master failed, the slave takes over as new master. Now

Re: [GENERAL] Queries Regarding Postgresql Replication

2011-05-05 Thread Josh Kupershmidt
On Thu, May 5, 2011 at 7:33 AM, Nithya Rajendran 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

[GENERAL] Queries Regarding Postgresql Replication

2011-05-05 Thread Nithya Rajendran
Hi , I have some couple of queries while doing postgres replication, ===> How to find whether current postgres is running as master or slave? > What is the procedure to make the failed master as working slave? Could you please clarify above queries. Thanks and Regards Nithya R Lead Engineer