Search Postgresql Archives

Re: Promoting 1 of 2 slaves

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



As I am aware, you would have two options depending on your configuration:
  1. Change the primary_conninfo value on the second standby's recovery.conf to point to the standby that has been promoted to master. However, I think this would require that instance to be rebooted for the configuration changes to take effect
  2. Modify the DNS entries so that the host value in primary_conninfo points to the new master rather than the old master
Does anyone know of another way?

Will J. Dunn

On Fri, Jul 17, 2015 at 9:43 AM, Joseph Kregloh <jkregloh@xxxxxxxxxxxxxx> wrote:
Hello,

I am getting ready to take my master server out of service today and promote the slave to take it's place. In my current setup I have one master server which ships WAL files to two separate slave servers.

My plan is to promote one of those slaves. How do I get the slave that I promoted to start replicating to the other slave the moment I trigger it's promotion?

Thanks,
-Joseph Kregloh


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux