Thread: Dynamically change Master(recovery info) without restarting standby server..

Hi,
  Is there any way to change the *master*  without restarting the *standby*
server. 

Postgresql Documentation says,  -->Recovery.conf file only read on the startup in standby mode. In that
file we specify the "Masterip".   -->If  you want to change the master we need to change the recovery.conf
file and restart the standby node. 
but,        *I Need to change masterip without restarting the standby node.*





-----
sudalai
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/Dynamically-change-Master-recovery-info-without-restarting-standby-server-tp5824423.html
Sent from the PostgreSQL - hackers mailing list archive at Nabble.com.



Re: Dynamically change Master(recovery info) without restarting standby server..

From
Michael Paquier
Date:
On Mon, Oct 27, 2014 at 8:45 PM, sudalai <sudalait2@gmail.com> wrote:
> Hi,
>
>    Is there any way to change the *master*  without restarting the *standby*
> server.
>
> Postgresql Documentation says,
>    -->Recovery.conf file only read on the startup in standby mode. In that
> file we specify the "Masterip".
>    -->If  you want to change the master we need to change the recovery.conf
> file and restart the standby node.
> but,
>      *I Need to change masterip without restarting the standby node.*
No. Restart the standby, documentation is clear here. Your need is
different from what can be done.
-- 
Michael