Postgres Pro
Downloads
Home   >   mailing lists

Thread: Replication After manual Failover

Replication After manual Failover

From
Yongye Serkfem
Date:
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.png
Attachment

Re: Replication After manual Failover

From
Muhammad Ikram
Date:
Hi,

Please reinitialize using pg_basebackup or use pg_rewind 



Muhammad Ikram
Bitnine Global


On Tue, 25 Jun 2024 at 22:20, Yongye Serkfem <yserkfem@gmail.com> 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 appreciated.
image.png
Attachment

Re: Replication After manual Failover

From
Ron Johnson
Date:
On Tue, Jun 25, 2024 at 2:39 PM Muhammad Ikram <mmikram@gmail.com> 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 <yserkfem@gmail.com> 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 appreciated.

[snip] 

Re: Replication After manual Failover

From
Ron Johnson
Date:
How were you replicating?

What was the status of the replication?

On Tue, Jun 25, 2024 at 1:20 PM Yongye Serkfem <yserkfem@gmail.com> 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 appreciated.
image.png
Attachment