Lists: | pgsql-hackers |
---|
From: | sudalai <sudalait2(at)gmail(dot)com> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Dynamically change Master(recovery info) without restarting standby server.. |
Date: | 2014-10-27 11:45:59 |
Message-ID: | 1414410359795-5824423.post@n5.nabble.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-hackers |
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.
From: | Michael Paquier <michael(dot)paquier(at)gmail(dot)com> |
---|---|
To: | sudalai <sudalait2(at)gmail(dot)com> |
Cc: | PostgreSQL mailing lists <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: Dynamically change Master(recovery info) without restarting standby server.. |
Date: | 2014-10-27 13:12:51 |
Message-ID: | CAB7nPqTR3X4PVhviED7i372MQDiNK9_EEZWQ2nn2HF3eD62FLA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-hackers |
On Mon, Oct 27, 2014 at 8:45 PM, sudalai <sudalait2(at)gmail(dot)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