Re: Replication After manual Failover

2024-06-25 Thread Ron Johnson
How were you replicating? What was the status of the replication? On Tue, Jun 25, 2024 at 1:20 PM Yongye Serkfem wrote: > Hello Engineer, > Below is the error message I am getting after failing over to the standby > and reconfiguring the former master as the new standby. Any help will be > appr

Re: Replication After manual Failover

2024-06-25 Thread Ron Johnson
On Tue, Jun 25, 2024 at 2:39 PM Muhammad Ikram wrote: > Hi, > > Please reinitialize using pg_basebackup > Might not be possible during a switchover. > or use pg_rewind > > > > Muhammad Ikram > Bitnine Global > > > On Tue, 25 Jun 2024 at 22:20, Yongye Serkfem wrote: > >> Hello Engineer, >> Bel

Re: Replication After manual Failover

2024-06-25 Thread Muhammad Ikram
Hi, Please reinitialize using pg_basebackup or use pg_rewind Muhammad Ikram Bitnine Global On Tue, 25 Jun 2024 at 22:20, Yongye Serkfem wrote: > Hello Engineer, > Below is the error message I am getting after failing over to the standby > and reconfiguring the former master as the new stand

Replication After manual Failover

2024-06-25 Thread Yongye Serkfem
Hello Engineer, Below is the error message I am getting after failing over to the standby and reconfiguring the former master as the new standby. Any help will be appreciated. [image: image.png]

Re: Manual Failover

2024-06-19 Thread Ron Johnson
On Wed, Jun 19, 2024 at 11:03 AM Yongye Serkfem wrote: > Hello Engineers, > I am facing an issue with the manual failover of the standby to the master > role. I was able to promote the standby and got it out of recovery mode. > How do I direct applications to point to the stand

Re: Manual Failover

2024-06-19 Thread Rob Sargent
On 6/19/24 09:03, Yongye Serkfem wrote: Hello Engineers, I am facing an issue with the manual failover of the standby to the master role. I was able to promote the standby and got it out of recovery mode. How do I direct applications to point to the standby which has assumed the role of

Manual Failover

2024-06-19 Thread Yongye Serkfem
Hello Engineers, I am facing an issue with the manual failover of the standby to the master role. I was able to promote the standby and got it out of recovery mode. How do I direct applications to point to the standby which has assumed the role of the current master, and what should I do after

Re: Manual failover cluster

2021-08-27 Thread Saul Perdomo
re side of >>> things, as long as there are no hardware nor operator issues! Again, not >>> knowing a lot about your setup, my first instinct would be to troubleshoot >>> your automated scripts, you might find that you need to change the order >>> things are run when o

Re: Manual failover cluster

2021-08-26 Thread Ninad Shah
here are no hardware nor operator issues! Again, not >> knowing a lot about your setup, my first instinct would be to troubleshoot >> your automated scripts, you might find that you need to change the order >> things are run when on server B vs server A, for example.. >> >&g

Re: Manual failover cluster

2021-08-23 Thread Saul Perdomo
ample.. > > On Fri, Aug 20, 2021 at 9:23 AM Hispaniola Sol > wrote: > >> Team, >> >> I have a pg 10 cluster with a master and two hot-standby nodes. There is >> a requirement for a manual failover (nodes switching the roles) at will. >> This is a vanilla 3 n

Re: Manual failover cluster

2021-08-23 Thread Saul Perdomo
des. There is a > requirement for a manual failover (nodes switching the roles) at will. This > is a vanilla 3 node PG cluster that was built with WAL archiving (central > location) and streaming replication to two hot standby nodes. The failover > is scripted in Ansible. Ansible massag

Re: Manual failover cluster

2021-08-23 Thread Ninad Shah
What are the parameters have you set in the recovery.conf file? Regards, Ninad Shah On Fri, 20 Aug 2021 at 18:53, Hispaniola Sol wrote: > Team, > > I have a pg 10 cluster with a master and two hot-standby nodes. There is a > requirement for a manual failover (nodes switching t

Manual failover cluster

2021-08-20 Thread Hispaniola Sol
Team, I have a pg 10 cluster with a master and two hot-standby nodes. There is a requirement for a manual failover (nodes switching the roles) at will. This is a vanilla 3 node PG cluster that was built with WAL archiving (central location) and streaming replication to two hot standby nodes